APPS.HR_APPROVAL_CUSTOM dependencies on PER_ALL_PEOPLE_F

Line 97: from per_all_people_f ppf

93: -- check if the start of the chain is a valid employee
94: begin
95: select ppf.person_id
96: into l_employee
97: from per_all_people_f ppf
98: where ppf.person_id = p_person_id
99: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
100: and (ppf.current_employee_flag = 'Y' Or ppf.current_npw_flag = 'Y') ;
101: exception

Line 117: from per_all_people_f ppf

113: -- check if the l_person_id is valid employee
114: begin
115: select ppf.person_id
116: into l_employee
117: from per_all_people_f ppf
118: where ppf.person_id = l_person_id
119: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
120: and (ppf.current_employee_flag = 'Y' Or ppf.current_npw_flag = 'Y');
121: exception

Line 137: from per_all_people_f ppf where ppf.person_id in (

133: begin
134:
135: select nvl(max(ppf.EFFECTIVE_END_DATE),sysdate+10)
136: into ed_date
137: from per_all_people_f ppf where ppf.person_id in (
138: select paf1.supervisor_id
139: from per_all_assignments_f paf1
140: where paf1.primary_flag = 'Y'
141: and paf1.assignment_type in ('E','C')

Line 216: ,per_all_people_f ppf

212: select ppf.person_id
213: from per_all_assignments_f paf
214: -- fix for bug # 1677216
215: --,per_people_f ppf
216: ,per_all_people_f ppf
217: where paf.person_id = l_in_person_id
218: and paf.primary_flag = 'Y'
219: and l_effective_date
220: between paf.effective_start_date

Line 232: ,per_all_people_f ppf

228: -- modified cursor to handle the issues reported
229: -- in bug#3007859
230: select ppf.person_id
231: from per_all_assignments_f paf
232: ,per_all_people_f ppf
233: where paf.person_id = l_in_person_id
234: and paf.primary_flag = 'Y'
235: and trunc(sysdate)
236: between paf.effective_start_date