APPS.PER_US_VALIDATE_PEI SQL Statements

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

Line: 56

  SELECT 1
  FROM  per_people_extra_info
  WHERE person_id    = p_person_id
    AND information_type = p_information_type
    AND fnd_date.canonical_to_date(pei_information7) >
       fnd_date.canonical_to_date(nvl(pei_information8,'4712/12/31 00:00:00'));

Line: 67

  SELECT count(*)
  FROM   per_people_extra_info
  WHERE  person_id    = p_person_id
    AND  information_type = p_information_type
    AND  pei_information5 = p_pei_information5
  HAVING count(*) > 1;

Line: 77

  SELECT count(*)
  FROM   per_people_extra_info
  WHERE  person_id    = p_person_id
    AND  information_type = p_information_type
    AND  pei_information10 = 'Y'
  HAVING count(*) > 1;

Line: 89

  SELECT count(*)
  FROM   per_people_extra_info
  WHERE  person_id    = p_person_id
    AND  information_type = p_information_type
    AND  pei_information5 = p_pei_information5
    AND  pei_information6 = p_pei_information6
  HAVING count(*) > 1;

Line: 100

  SELECT fnd_date.canonical_to_date(pei_information7) start_date,
         fnd_date.canonical_to_date(nvl(pei_information8,'4712/12/31 00:00:00'))
               end_date
  FROM  per_people_extra_info
  WHERE person_id    = p_person_id
    AND information_type = p_information_type
  ORDER BY start_date asc;