182: AND paf.assignment_type IN ('E','C')
183: START WITH paf.assignment_id = EMP_ASSIGNMENT_ID
184: CONNECT BY NOCYCLE PRIOR paf.person_id = nvl(paf.supervisor_id,-1))
185: SUPH ,
186: PER_PAY_BASES PPB ,
187: PER_PAY_PROPOSALS PRO ,
188: PAY_INPUT_VALUES_F PIV ,
189: PAY_ELEMENT_TYPES_F PET ,
190: HR_LOCATIONS_ALL LOC ,