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