APPS.FII_CC_MGR_SUP_C dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 154: per_assignment_status_types ast

150: select /*+ leading(ct) full(ct) index(suph HRI_CS_SUPH_N4) use_nl(ct suph) */
151: distinct suph.sup_person_id
152: from fii_ccc_mgr_gt ct,
153: hri_cs_suph suph,
154: per_assignment_status_types ast
155: where ct.manager = suph.sub_person_id
156: and sysdate between suph.effective_start_date
157: and suph.effective_end_date
158: and suph.sup_assignment_status_type_id = ast.assignment_status_type_id