APPS.PSP_LABOR_DIST dependencies on PER_ALL_PEOPLE_F

Line 6888: from per_all_people_f

6884: order by effective_end_date desc;
6885:
6886: cursor get_person_name(p_person_id integer) is
6887: select full_name
6888: from per_all_people_f
6889: where person_id = p_person_id;
6890:
6891: cursor get_control_details(p_payroll_control_id integer) is
6892: select time_period_id,

Line 7960: from per_all_people_f ppf,

7956: p_eff_date in date) is
7957: select ppf.full_name,
7958: paf.assignment_number,
7959: hou.name
7960: from per_all_people_f ppf,
7961: per_all_assignments_f paf,
7962: hr_all_organization_units hou
7963: where ppf.person_id = p_person_id
7964: and p_eff_date between ppf.effective_start_date and ppf.effective_end_date