APPS.PER_NL_DSRR_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO
Line 1311: ,per_people_extra_info pei
1307: ,pei_information22 est_name
1308: ,pei_information23 gender
1309: ,pei_information24 contact_ph_no
1310: FROM per_all_assignments_f pas 1311: ,per_people_extra_info pei 1312: WHERE pas.assignment_id = p_assignment_id
1313: AND p_start_date BETWEEN pas.effective_start_date
1314: AND pas.effective_end_date
1315: AND pei.person_id = pas.person_id