APPS.PQP_GB_AD_EE dependencies on PER_ALL_PEOPLE_F

Line 1553: per_all_people_f pap,

1549: cursor csr_is_paye_aggregated
1550: is
1551: select pap.per_information10 per_agg_flag
1552: from
1553: per_all_people_f pap,
1554: pay_element_entries_f peef,
1555: per_all_assignments_f paaf
1556: where
1557: peef.element_entry_id = p_element_entry_id

Line 1756: per_all_people_f pap,

1752: cursor csr_is_paye_aggregated
1753: is
1754: select pap.per_information10 per_agg_flag
1755: from
1756: per_all_people_f pap,
1757: pay_element_entries_f peef,
1758: per_all_assignments_f paaf
1759: where
1760: peef.element_entry_id = p_element_entry_id

Line 2093: FROM per_all_people_f papf,

2089: hr_utility.set_location('PAYE l_paye_assg_id :'||l_paye_assg_id ,18);
2090:
2091: SELECT papf.per_information10
2092: INTO l_paye_agg
2093: FROM per_all_people_f papf,
2094: per_all_assignments_f paaf
2095: WHERE paaf.assignment_id = l_paye_assg_id
2096: AND paaf.person_id = papf.person_id
2097: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date