APPS.PER_US_VALIDATE_AEI SQL Statements

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

Line: 47

  SELECT count(*)
  FROM   per_assignment_extra_info
  WHERE  assignment_id    = p_assignment_id
    AND  information_type = p_information_type
    AND  aei_information1 = p_aei_information1
    AND  aei_information3 = p_aei_information3
  HAVING count(*) > 1;

Line: 59

SELECT count(*) ct
  FROM hr_organization_information orgi,
       per_assignments_f paf,
       hr_soft_coding_keyflex sft
 WHERE orgi.organization_id          = to_number(sft.segment1)
   AND sft.soft_coding_keyflex_id    = paf.soft_coding_keyflex_id
   AND paf.assignment_id             = p_assignment_id
   AND orgi.org_information1         = p_aei_information1
   AND orgi.org_information_context  = 'PAY_US_STATE_WAGE_PLAN_INFO'
   AND orgi.org_information3         = p_aei_information3;