APPS.PQH_NR_ALIEN_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

   select 1 from per_people_extra_info pei
   where pei.information_type = 'PER_US_VISA_DETAILS'
   and pei.person_id = cp_person_id
   and fnd_date.date_to_canonical(cp_report_date)between pei_information7 and pei_information8
   and pei_information9 in ('04','05','06','07','12');