UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='P' WHERE ID=2038 OR ID =2039 OR ID =2040

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID = 2039
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID = 2040

UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE ID=2041 

DELETE FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE PROCESS_ID NOT IN(SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='PLRD00000200091')

UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='TC' WHERE REQ_ID='PLRD00000200091'


SELECT * FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE REQ_ID='PLRD00000200054'

UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='P' WHERE ID=2026 

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID = 2029
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID = 2030

UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE ID=2031 

DELETE FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE PROCESS_ID NOT IN(SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='PLRD00000200054')

UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='TC' WHERE REQ_ID='PLRD00000200054'