APPS.PQH_NR_ALIEN_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 11: select 1 from per_people_extra_info pei

7:
8: cursor c1(cp_person_id number, cp_report_date date)
9: is
10:
11: select 1 from per_people_extra_info pei
12: where pei.information_type = 'PER_US_VISA_DETAILS'
13: and pei.person_id = cp_person_id
14: and fnd_date.date_to_canonical(cp_report_date)between pei_information7 and pei_information8
15: and pei_information9 in ('04','05','06','07','12');