I want to add the SUM(BL_US_CURY_AMT) + FUND_CASH_BAL_AMT into FUND_CASH_BAL_AMT.

[jestin paul dav]

UPDATE BFD02.FUND_ARGMT_PARM FP
SET FUND_CASH_BAL_AMT = FUND_CASH_BAL_AMT +
(SELECT SUM(BL_US_CURY_AMT)
FROM BFD02.FUND_ARGMT_FIN_AMT FA
WHERE FA.VAL_CTG_CD = 'I'
AND FA.VAL_QUAL_CD = 'IP'
AND FA.VAL_ASCR_CD = ' '
AND FA.DATA_EFF_DT = (SELECT PROC_DT FROM BFD02.BATCH_PARM
WHERE PARM_KEY_ID = 'PROC-DATE')
AND FP.FDARR_ID = FA.FDARR_ID)
,LST_UD_TRN_ID = CURRENT TIMESTAMP
WHERE FP.FDARR_ID IN
(SELECT DISTINCT F2.FDARR_ID
FROM BFD02.FUND_ARGMT_FIN_AMT F1,
BFD02.FUND_ARGMT_PARM F2
WHERE F1.FDARR_ID = F2.FDARR_ID
AND F2.VAL_QUAL_CD IN ('CCI','CCV','LRF','FDD','FNR'));

Look into the above update query. I want to add the SUM(BL_US_CURY_AMT) + FUND_CASH_BAL_AMT into FUND_CASH_BAL_AMT.
BFD02 is the Database.

IS The above query is ok for that.? or else please guide me in to it.
Thanks,
Jestin