DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000346')
UPDATE TR_REQUEST_DOC SET TOTAL_AMT = TOTAL_AMT -1100000000 WHERE REQ_ID =@REQ_ID
DELETE FROM TR_REQUEST_DOC_PL_DT WHERE REQPL_DT_ID ='TRPLD0000003041'
DELETE FROM TR_REQUEST_DOC_DT WHERE REQDT_ID ='TRRDD0000257710'