APPS.HR_CANCEL_HIRE_API SQL Statements

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

Line: 34

  SELECT DISTINCT
         paa.business_group_id
        ,pos.period_of_service_id
        ,pos.date_start
  FROM   per_periods_of_service pos
        ,per_all_assignments_f paa
  WHERE  paa.person_id = p_person_id
  AND    p_effective_date BETWEEN
         paa.effective_start_date AND paa.effective_end_date
  AND    paa.person_id = pos.person_id
--
-- 115.3 (START)
--
  AND    pos.date_start IN
         (SELECT MAX(pos2.date_start)
          FROM   per_periods_of_service pos2
          WHERE  pos2.person_id = p_person_id)
--
-- 115.3 (END)
--
 AND    paa.period_of_service_id = pos.period_of_service_id;

Line: 58

   SELECT DISTINCT
          paa.business_group_id
         ,pos.period_of_service_id
         ,pos.date_start
   FROM   per_periods_of_service pos
         ,per_all_assignments_f paa
   WHERE  paa.person_id = p_person_id
   AND    p_effective_date BETWEEN
          paa.effective_start_date AND paa.effective_end_date
   AND    paa.person_id = pos.person_id
   AND    paa.period_of_service_id = pos.period_of_service_id;