APPS.PER_ADDRESSES_PKG dependencies on PER_PEOPLE_EXTRA_INFO
Line 20: FROM per_people_extra_info pei
16: ) As
17: -- Cursor to check if person is student
18: CURSOR csr_stu (c_person_id IN Number) IS
19: SELECT pei.pei_information5 20: FROM per_people_extra_info pei 21: WHERE pei.information_type = 'PQP_OSS_PERSON_DETAILS'
22: AND pei.pei_information_category = 'PQP_OSS_PERSON_DETAILS'
23: AND pei.person_id = c_person_id;
24: