SELECT * FROM PL_REQUEST_PROCESS PLRP
      WHERE PLRP.REQ_ID='PLRD00000204964' AND PLRP.STATUS = 'C' AND ((PLRP.PROCESS_ID = 'DVCM' AND EXISTS(
      SELECT pc.COST_ID FROM PL_COSTCENTER pc
      LEFT JOIN PL_COSTCENTER_DT pcd ON pc.COST_ID = pcd.COST_ID
      LEFT JOIN CM_DEPARTMENT cd ON pcd.DEP_ID = cd.DEP_ID OR pcd.DEP_ID = cd.FATHER_ID
      LEFT JOIN TL_USER tu1 ON pcd.BRANCH_ID = tu1.TLSUBBRID AND cd.DEP_ID = tu1.SECUR_CODE
      WHERE (pc.DVDM_ID = PLRP.DVDM_ID OR PLRP.DVDM_ID IS NULL OR PLRP.DVDM_ID = '')
      AND tu1.TLNANME = 'nganhtk'))
      OR (PLRP.PROCESS_ID = 'DVDC' AND EXISTS(
      SELECT prt.REQ_TRANSFER_ID FROM PL_REQUEST_TRANSFER prt
      LEFT JOIN TL_USER tu1 ON prt.FR_BRN_ID = tu1.TLSUBBRID AND prt.FR_DEP_ID = tu1.SECUR_CODE
      WHERE prt.FR_BRN_ID = PLRP.BRANCH_ID AND prt.FR_DEP_ID = PLRP.DEP_ID AND prt.REQ_DOC_ID = PLRP.REQ_ID
      AND tu1.TLNANME = 'nganhtk'))
      OR PLRP.PROCESS_ID NOT IN ('DVCM','DVDC'))