APPS.PER_NL_LTSR_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO
Line 1323: ,per_people_extra_info pei
1319: ,pei_information23 gender
1320: ,pei_information24 contact_ph_no
1321: -- ,pei_information3 l29bzw
1322: FROM per_all_assignments_f pas 1323: ,per_people_extra_info pei 1324: WHERE pas.assignment_id = p_assignment_id
1325: AND p_start_date BETWEEN pas.effective_start_date
1326: AND pas.effective_end_date
1327: AND pei.person_id = pas.person_id