APPS.PAY_NL_ATS_REPORT dependencies on PER_ALL_PEOPLE_F

Line 67: per_all_people_f pap,

63: from
64: pay_assignment_actions assact,
65: pay_action_information pai,
66: per_all_assignments_f paa,
67: per_all_people_f pap,
68: per_periods_of_service ppos,
69: hr_organization_units hou,
70: hr_organization_information hoi
71: where

Line 122: select full_name from per_all_people_f

118: from hr_organization_units
119: where organization_id = lp_org_id;
120:
121: CURSOR csr_get_person_name(lp_person_id number,lp_effective_date date) IS
122: select full_name from per_all_people_f
123: where person_id = lp_person_id
124: and lp_effective_date between effective_start_date and effective_end_date;
125:
126: CURSOR csr_org_glb_address(p_bg_id NUMBER, p_org_id NUMBER) IS

Line 1664: per_all_people_f pap,

1660: from
1661: pay_assignment_actions assact,
1662: pay_action_information pai,
1663: per_all_assignments_f paa,
1664: per_all_people_f pap,
1665: per_periods_of_service ppos,
1666: hr_organization_units hou,
1667: hr_organization_information hoi
1668: where

Line 1719: select full_name from per_all_people_f

1715: from hr_organization_units
1716: where organization_id = lp_org_id;
1717:
1718: CURSOR csr_get_person_name(lp_person_id number,lp_effective_date date) IS
1719: select full_name from per_all_people_f
1720: where person_id = lp_person_id
1721: and lp_effective_date between effective_start_date and effective_end_date;
1722:
1723: CURSOR csr_org_glb_address(p_bg_id NUMBER, p_org_id NUMBER) IS