SELECT * FROM TR_CONTRACT WHERE CONTRACT_ID ='TRC000000252346'
DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NCC.2021.000567')
DELETE FROM TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID =@REQ_ID
DELETE FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID =@REQ_ID
UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS ='E' WHERE REQ_PAY_ID =@REQ_ID