UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID= (SELECT TOP 1 T.PROCESS_ID FROM dbo.PL_REQUEST_PROCESS T  WHERE T.REQ_ID=PL_REQUEST_PROCESS.REQ_ID AND T.PROCESS_ID <>'APPROVE' ORDER BY T.ID DESC) WHERE  
 PROCESS_ID='APPROVE' AND PARENT_PROCESS_ID='PTGD_DC'
 UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE PROCESS_ID='APPROVE' AND REQ_ID IN (SELECT REQ_ID FROM dbo.PL_REQUEST_PROCESS WHERE STATUS <>'C')