DBA Data[Home] [Help]

APPS.HR_CCMGR_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 14: From per_all_people_f s, per_all_assignments_f paf

10:
11: -- Cursors
12: cursor c_supDetails (p_id Number) IS
13: Select s.full_name, s.person_id
14: From per_all_people_f s, per_all_assignments_f paf
15: Where paf.person_id = p_id
16: and paf.supervisor_id = s.person_id
17: and paf.primary_flag = 'Y'
18: and s.current_employee_flag = 'Y'