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 ='PTGDK_TT' AND R.STATUS IN ('C','U')
WHERE P.PROCESS_ID <> 'APPROVE' AND YEAR(CREATE_DT)=2022 AND  P.PROCESS_ID<> 'REJECT' AND R.DVDM_ID ='DM0000000000015'