APPS.PER_PERRPFP3_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 33: from per_all_people_f peo

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

Line 489: per_all_people_f peo

485: begin
486: select count(*)
487: into v_detailcount
488: from per_periods_of_service pps,
489: per_all_people_f peo
490: where pps.person_id = p_person_id
491: and pps.business_group_id = p_business_group_id
492: and pps.termination_accepted_person_id = peo.person_id(+)
493: and pps.actual_termination_date between peo.effective_start_date(+)

Line 504: per_all_people_f peo

500: begin
501: select count(*)
502: into v_detailcount
503: from per_all_assignments_f asg,
504: per_all_people_f peo
505: where asg.supervisor_id = peo.person_id(+)
506: and asg.effective_start_date between peo.effective_start_date(+)
507: and peo.effective_end_date(+)
508: and asg.business_group_id = p_business_group_id