DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=1506 UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE ID=1507 UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID='PLRD00000200132' EXEC dbo.PL_REQ_DOC_UPDATE_AFTER_APPROVE @p_REQ_ID = 'PLRD00000200132'; EXEC dbo.PL_REQ_DOC_Ins_To_TR_REQ_DOC @p_PL_REQ_ID = 'PLRD00000200132';