SELECT P.REQ_ID, P.REQ_CODE, P.AUTH_STATUS, P.PROCESS_ID FROM PL_REQUEST_DOC P
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID =R.REQ_ID AND R.PROCESS_ID ='TGD' AND R.STATUS IN ('C','U')
WHERE P.PROCESS_ID <> 'APPROVE' AND YEAR(CREATE_DT)=2022 AND  P.PROCESS_ID<> 'REJECT' AND P.PROCESS_ID <> 'TGD'