DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000937')
UPDATE TR_REQUEST_DOC SET AUTH_STATUS ='E', PROCESS_ID ='' WHERE REQ_ID =@REQ_ID
EXEC TR_REQUEST_DOC_Del @REQ_ID

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001050')
UPDATE TR_REQUEST_DOC SET AUTH_STATUS ='E', PROCESS_ID ='' WHERE REQ_ID =@REQ_ID
EXEC TR_REQUEST_DOC_Del @REQ_ID

SET @REQ_ID=(SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO017/21/0002')
EXEC TR_PO_MASTER_Del @REQ_ID

SET @REQ_ID=(SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO017/21/0003')
EXEC TR_PO_MASTER_Del @REQ_ID

UPDATE PL_TRADEDETAIL SET AMT_EXE =0 WHERE AMT_EXE IS NULL