APPS.HXC_TIMEKEEPER_PROCESS dependencies on PER_PEOPLE_F

Line 110: FROM per_people_f ppf2, per_all_assignments_f paa2

106: AND ppf.person_id = NVL (p_resource_id, ppf.person_id)
107: AND htgq.include_exclude = 'I'
108: AND htgqc.criteria_type = 'PERSON'
109: AND ppf.effective_end_date = (SELECT MAX (ppf2.effective_end_date)
110: FROM per_people_f ppf2, per_all_assignments_f paa2
111: WHERE ppf2.person_id = paa2.person_id
112: AND paa2.primary_flag = 'Y'
113: AND paa2.assignment_type IN ('E', 'C')
114: AND p_start_period <= paa2.effective_end_date

Line 156: FROM per_people_f ppf2, per_all_assignments_f paa2

152: AND htg.business_group_id = ppf.business_group_id
153: AND htgq.include_exclude = 'I'
154: AND htgqc.criteria_type = 'PERSON'
155: AND ppf.effective_end_date = (SELECT MAX (ppf2.effective_end_date)
156: FROM per_people_f ppf2, per_all_assignments_f paa2
157: WHERE ppf2.person_id = paa2.person_id
158: AND paa2.primary_flag = 'Y'
159: AND paa2.assignment_type IN ('E', 'C')
160: AND p_start_period <= paa2.effective_end_date

Line 6259: FROM per_people_f ppf

6255: ) IS
6256: SELECT DISTINCT NVL (ppf.employee_number, ppf.npw_number) employee_number,
6257: ppf.full_name,
6258: ppf.effective_end_date
6259: FROM per_people_f ppf
6260: WHERE ppf.person_id = p_resource_id
6261: AND p_from_period < ppf.effective_end_date
6262: AND p_to_period > ppf.effective_start_date
6263: AND EXISTS ( select 'x'