APPS.PAY_MX_PAYREG_PKG dependencies on PER_ALL_PEOPLE_F

Line 996: per_all_people_f pap

992: CURSOR c_get_emp_name(assigid number) is
993: SELECT pap.full_name
994: ,paf.assignment_number
995: FROM per_assignments_f paf,
996: per_all_people_f pap
997: WHERE paf.assignment_id = assigid
998: AND pap.person_id = paf.person_id;
999:
1000: CURSOR c_get_payroll_period (asg_action_id NUMBER) is

Line 1637: ,per_all_people_f ppf

1633: hr_utility.set_location ('Entering '||l_proc_name ,15);
1634: SELECT ppf.full_name
1635: INTO return_val
1636: FROM per_all_assignments_f paf
1637: ,per_all_people_f ppf
1638: WHERE paf.person_id = ppf.person_id
1639: AND c_effective_date BETWEEN
1640: paf.effective_start_date AND paf.effective_end_date
1641: AND c_effective_date BETWEEN

Line 1651: ,per_all_people_f papf

1647: SELECT ppf.payroll_name||' '||papf.full_name
1648: INTO return_val
1649: FROM per_all_assignments_f paf
1650: ,pay_payrolls_f ppf
1651: ,per_all_people_f papf
1652: WHERE paf.payroll_id = ppf.payroll_id
1653: AND c_effective_date BETWEEN
1654: paf.effective_start_date AND paf.effective_end_date
1655: AND c_effective_date BETWEEN