Filtering tambahan

SELECT PERSON_ID, PERSON_FULL_NAME
    FROM (SELECT PERSON_ID, PERSON_FULL_NAME, 0 IDX
            FROM HRMS.HR_PEOPLE_ALL
           WHERE PERSON_ID = 9177 -- spv
          UNION
          SELECT A.HIER_PERSON_ID, B.PERSON_FULL_NAME, A.HIER_LEVEL IDX
            FROM SHCM.CM_TGH_MST_HIERARCHIES A, HRMS.HR_PEOPLE_ALL B
           WHERE     A.HIER_PERSON_ID = B.PERSON_ID
                 AND B.PERSON_STATUS IN ('VR', 'WA', 'AC')
                 AND A.HIER_CYCLE = DECODE(:CFIN_AR_BEBAN_GTT.BBN_CYCLE_AWAL,'CN','C0',:CFIN_AR_BEBAN_GTT.BBN_CYCLE_AWAL)
                 AND A.HIER_COYOUTLET_ID = '2634' -- cabang
                 AND A.HIER_COLL_TYPE = NVL(:CTRL.COLL_TYPE,A.HIER_COLL_TYPE)
                 AND A.HIER_PERSON_ID <> :CFIN_AR_BEBAN_GTT.BBN_COLL_ID
                 AND A.HIER_LEVEL IN (SELECT C.PARAM_VALUE
                                        FROM APPL.APPL_MST_PARAM C
                                       WHERE C.PARAM_KEY IN ('JL_COLL'))
                 AND A.HIER_UP_LEVEL || A.HIER_UP_SUB_LEVEL IN
                         (SELECT D.HIER_LEVEL || D.HIER_SUB_LEVEL
                            FROM SHCM.CM_TGH_MST_HIERARCHIES D
                           WHERE D.HIER_PERSON_ID = 9177) -- spv
                 -- TAMBAHAN SETUP SURVEYOR
                 AND PERSON_ID NOT IN
                         (SELECT DTL.SURD_PERSON_ID
                            FROM CFIN.CFIN_MST_SURVEYOR_HDR HDR,
                                 CFIN.CFIN_MST_SURVEYOR_DTL DTL
                           WHERE     HDR.SURH_OUTLET_ID = DTL.SURD_OUTLET_ID
                                 AND HDR.SURH_OUTLET_ID = A.HIER_COYOUTLET_ID
                                 AND DTL.SURD_PERSON_ID = PERSON_ID
                                 AND DTL.SURD_TYPE = 'COL'
                                 AND HDR.SURH_STATUS = 'AC'))
ORDER BY IDX;