DBA Data[Home] [Help]

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2597: , per_assignment_extra_info paei

2593: select ppf.person_id
2594: , paa.assignment_id
2595: from per_all_people_f ppf
2596: , per_all_assignments_f paa
2597: , per_assignment_extra_info paei
2598: , pay_payroll_actions ppa_arch
2599: , per_periods_of_service pps
2600: where paa.business_group_id = g_bg_id
2601: and paa.person_id = ppf.person_id

Line 4181: , per_assignment_extra_info paei

4177: , l_ass_cat_name
4178: From per_all_assignments_f paaf
4179: , pay_assignment_actions paa
4180: , per_all_people_f perf
4181: , per_assignment_extra_info paei
4182: Where paa.assignment_action_id = p_assactid
4183: and paa.assignment_id = paaf.assignment_id
4184: and paaf.person_id = perf.person_id
4185: and p_effective_date between perf.effective_start_date