SELECT * FROM PL_REQUEST_DOC WHERE PROCESS_ID <>'APPROVE' AND REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_PROCESS WHERE STATUS ='C' AND PROCESS_ID ='APPROVE') AND YEAR(CREATE_DT)=2023