DBA Data[Home] [Help]

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2603: , per_assignment_extra_info paei

2599: select ppf.person_id
2600: , paa.assignment_id
2601: from per_all_people_f ppf
2602: , per_all_assignments_f paa
2603: , per_assignment_extra_info paei
2604: , pay_payroll_actions ppa_arch
2605: , per_periods_of_service pps
2606: where paa.business_group_id = g_bg_id
2607: and paa.person_id = ppf.person_id

Line 4187: , per_assignment_extra_info paei

4183: , l_ass_cat_name
4184: From per_all_assignments_f paaf
4185: , pay_assignment_actions paa
4186: , per_all_people_f perf
4187: , per_assignment_extra_info paei
4188: Where paa.assignment_action_id = p_assactid
4189: and paa.assignment_id = paaf.assignment_id
4190: and paaf.person_id = perf.person_id
4191: and p_effective_date between perf.effective_start_date