APPS.PER_NL_WAZO_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO
Line 1466: ,per_people_extra_info pei
1462: ,pei_information22 est_name
1463: ,pei_information23 gender
1464: ,pei_information24 contact_ph_no
1465: FROM per_all_assignments_f pas 1466: ,per_people_extra_info pei 1467: WHERE pas.assignment_id = p_assignment_id
1468: AND p_start_date BETWEEN pas.effective_start_date
1469: AND pas.effective_end_date
1470: AND pei.person_id = pas.person_id