UPDATE TR_REQ_PAY_PERIOD SET PROCESS ='2' WHERE REQ_PAY_ID
IN (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE ISNULL (REQ_AMT,0) = ISNULL(PAY_AMT,0)) AND PROCESS <> '2'
UPDATE TR_REQ_PAY_INVOICE SET INVOICE_NO = INVOICE_NO +'REMOVE' WHERE REQ_PAY_ID NOT IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT)