DBA Data[Home] [Help]

APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PER_ALL_POSITIONS

Line 2634: , per_all_positions pap

2630: --, a.location_id
2631: , nvl(a.location_id, nvl(pap.location_id, haou.location_id)) location_id
2632: from per_all_people_f ppf
2633: , per_all_assignments_f a
2634: , per_all_positions pap
2635: , hr_all_organization_units haou
2636: where a.assignment_id = p_assignment_id
2637: and ppf.person_id = a.person_id
2638: and l_effective_date between a.effective_start_date and a.effective_end_date