DBA Data[Home] [Help]

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: