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');