SELECT * FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE PROCESS_ID='APPROVE') AND PROCESS_ID ='APPROVE' AND STATUS='U'


UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE ID IN (SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE PROCESS_ID='APPROVE') AND PROCESS_ID ='APPROVE' AND STATUS='U'

)