UPDATE  PL_REQUEST_PROCESS SET IS_HAS_CHILD='1'  WHERE REQ_ID IN (SELECT P.REQ_ID FROM PL_REQUEST_DOC P
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID = R.REQ_ID AND R.PROCESS_ID ='DVDM_DC' AND R.STATUS ='U' AND R.DVDM_ID ='DM0000000000003'

AND P.TOTAL_AMT <10000000 AND YEAR(REQ_DT)=2022 AND P.PROCESS_ID <> 'REJECT')
AND PROCESS_ID ='DVDM_DC'