APPS.PER_PERRPFP4_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 31: from per_all_people_f peo

27: select peo.first_name ||
28: decode(peo.first_name,null,null,' ') ||
29: peo.last_name
30: into v_name
31: from per_all_people_f peo
32: where peo.person_id = p_person_id
33: and p_session_date between peo.effective_start_date
34: and peo.effective_end_date;
35: c_header_name := v_name;

Line 258: from per_all_people_f peo

254: || peo.first_name
255: || decode(peo.first_name,null,null,' ')
256: || peo.last_name
257: into v_authorizer_name
258: from per_all_people_f peo
259: , hr_lookups hr1
260: where AUTHORISING_PERSON_ID = peo.person_id
261: and peo.effective_start_date = (select min(peo2.effective_start_date)
262: from per_all_people_f peo2

Line 262: from per_all_people_f peo2

258: from per_all_people_f peo
259: , hr_lookups hr1
260: where AUTHORISING_PERSON_ID = peo.person_id
261: and peo.effective_start_date = (select min(peo2.effective_start_date)
262: from per_all_people_f peo2
263: where peo2.person_id = peo.person_id)
264: and hr1.lookup_type (+) = 'TITLE'
265: and hr1.lookup_code (+) = peo.title;
266:

Line 276: from per_all_people_f peo

272: || peo.first_name
273: || decode(peo.first_name,null,null,' ')
274: || peo.last_name
275: into v_replacement_name
276: from per_all_people_f peo
277: , hr_lookups hr1
278: where replacement_PERSON_ID = peo.person_id
279: and peo.effective_start_date = (select min(peo2.effective_start_date)
280: from per_all_people_f peo2

Line 280: from per_all_people_f peo2

276: from per_all_people_f peo
277: , hr_lookups hr1
278: where replacement_PERSON_ID = peo.person_id
279: and peo.effective_start_date = (select min(peo2.effective_start_date)
280: from per_all_people_f peo2
281: where peo2.person_id = peo.person_id )
282: and hr1.lookup_type (+) = 'TITLE'
283: and hr1.lookup_code (+) = peo.title;
284: