declare @req_pay_id varchar(15), @ref_id varchar(15)
DECLARE cursorProduct CURSOR FOR
SELECT REQ_PAY_ID,REF_ID FROM TR_REQ_ADVANCE_PAYMENT A WHERE A.REQ_TYPE ='I'
Open cursorProduct
FETCH NEXT FROM cursorProduct INTO @req_pay_id, @ref_id
WHILE @@FETCH_STATUS = 0
BEGIN
   UPDATE TR_REQ_ADVANCE_PAYMENT SET RECEIVER_DEBIT =(SELECT ISNULL(ACC_NUM,'') FROM CM_ACCOUNT_PAY WHERE REF_ID =@ref_id AND ACC_TYPE ='ADV_PAY' ) WHERE REQ_PAY_ID =@req_pay_id
FETCH NEXT FROM cursorProduct INTO  @req_pay_id, @ref_id
END