APPS.PER_US_HR_UTILITY_PKG SQL Statements

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

Line: 21

   SELECT 0
   FROM   per_people_extra_info pei
   WHERE  pei.person_id        = cp_person_id
   AND    pei.information_type = 'PER_US_VISA_DETAILS'
   AND    fnd_date.date_to_canonical(cp_report_date) BETWEEN pei_information7 AND pei_information8
   AND    pei_information9 IN ('04','05','06','07','12');

Line: 30

   SELECT pei.pei_information1,
          pei.pei_information2,
          pei.pei_information3,
          pei.pei_information4,
          pei.pei_information5,
          pei.pei_information6,
          pei.pei_information7
   FROM   per_people_extra_info pei
   WHERE  pei.person_id = cp_person_id
   AND    pei.information_type = 'US_ETHNIC_ORIGIN';

Line: 112

   SELECT pei.pei_information1,
          pei.pei_information2,
          pei.pei_information3,
          pei.pei_information4,
          pei.pei_information5,
          pei.pei_information6,
          pei.pei_information7
   FROM   per_people_extra_info pei
   WHERE  pei.person_id = cp_person_id
   AND    pei.information_type = 'US_ETHNIC_ORIGIN';