APPS.PER_US_HR_UTILITY_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 22: FROM per_people_extra_info pei

18:
19: CURSOR csr_alien(cp_person_id NUMBER, cp_report_date DATE)
20: IS
21: SELECT 0
22: FROM per_people_extra_info pei
23: WHERE pei.person_id = cp_person_id
24: AND pei.information_type = 'PER_US_VISA_DETAILS'
25: AND fnd_date.date_to_canonical(cp_report_date) BETWEEN pei_information7 AND pei_information8
26: AND pei_information9 IN ('04','05','06','07','12');

Line 37: FROM per_people_extra_info pei

33: pei.pei_information4,
34: pei.pei_information5,
35: pei.pei_information6,
36: pei.pei_information7
37: FROM per_people_extra_info pei
38: WHERE pei.person_id = cp_person_id
39: AND pei.information_type = 'US_ETHNIC_ORIGIN';
40:
41: l_ethnic_origin NUMBER;

Line 119: FROM per_people_extra_info pei

115: pei.pei_information4,
116: pei.pei_information5,
117: pei.pei_information6,
118: pei.pei_information7
119: FROM per_people_extra_info pei
120: WHERE pei.person_id = cp_person_id
121: AND pei.information_type = 'US_ETHNIC_ORIGIN';
122:
123: l_ethnic_origin NUMBER;