APPS.PAY_AC_ACTION_ARCH dependencies on PER_ALL_PEOPLE_F

Line 2234: ,per_all_people_f ppf

2230: SELECT NVL(paf.work_at_home, 'N')
2231: ,ppf.person_id
2232: ,ppf.business_group_id
2233: FROM per_assignments_f paf
2234: ,per_all_people_f ppf
2235: WHERE paf.assignment_id = cp_assignment_id
2236: AND paf.person_id = ppf.person_id
2237: and p_curr_pymt_eff_date between paf.effective_start_date and paf.effective_end_date
2238: and p_curr_pymt_eff_date between ppf.effective_start_date and ppf.effective_end_date; -- Bug# 16318258

Line 4896: ,per_all_people_f ppf

4892: SELECT NVL(paf.work_at_home, 'N')
4893: ,ppf.person_id
4894: ,ppf.business_group_id
4895: FROM per_assignments_f paf
4896: ,per_all_people_f ppf
4897: WHERE paf.assignment_id = cp_assignment_id
4898: AND paf.person_id = ppf.person_id
4899: and cp_pymt_eff_date between paf.effective_start_date and paf.effective_end_date
4900: and cp_pymt_eff_date between ppf.effective_start_date and ppf.effective_end_date; -- Bug# 16318258

Line 5469: ,per_all_people_f ppf

5465: SELECT NVL(paf.work_at_home, 'N')
5466: ,ppf.person_id
5467: ,ppf.business_group_id
5468: FROM per_assignments_f paf
5469: ,per_all_people_f ppf
5470: WHERE paf.assignment_id = cp_assignment_id
5471: AND paf.person_id = ppf.person_id
5472: and cp_pymt_eff_date between paf.effective_start_date and paf.effective_end_date
5473: and cp_pymt_eff_date between ppf.effective_start_date and ppf.effective_end_date; -- Bug# 16318258

Line 6070: ,per_all_people_f ppf

6066: SELECT NVL(paf.work_at_home, 'N')
6067: ,ppf.person_id
6068: ,ppf.business_group_id
6069: FROM per_assignments_f paf
6070: ,per_all_people_f ppf
6071: WHERE paf.assignment_id = cp_assignment_id
6072: AND paf.person_id = ppf.person_id
6073: and cp_pymt_eff_date between paf.effective_start_date and paf.effective_end_date
6074: and cp_pymt_eff_date between ppf.effective_start_date and ppf.effective_end_date; -- Bug# 16318258