APPS.PER_AU_ASG_LEG_HOOK SQL Statements

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

Line: 4

 PROCEDURE UPDATE_AU_ASG
 (p_assignment_id       IN   NUMBER
 ,p_effective_date      IN   DATE
 ,p_segment1            IN  VARCHAR2
 ) AS

  CURSOR c_check_actions
  (c_assignment_id per_all_assignments_f.assignment_id%TYPE
  ,c_effective_date  DATE
  ) IS
      SELECT 'Y'
      FROM  per_all_assignments_f paaf
      ,     pay_payroll_actions   ppa
      ,     pay_assignment_actions paa
      WHERE paaf.assignment_id     = c_assignment_id
      AND   paaf.assignment_id     = paa.assignment_id
      AND   paaf.business_group_id = ppa.business_group_id
      AND   ppa.payroll_action_id  = paa.payroll_action_id
      AND   ppa.effective_date    >=    (SELECT ptp.start_date
                      FROM per_time_periods ptp
                      WHERE ptp.payroll_id = ppa.payroll_id
                      AND c_effective_date BETWEEN ptp.start_date AND ptp.end_date)
      and  ppa.action_type IN ('Q','R','B','I','V');

Line: 32

      SELECT hsc.segment1
      FROM   per_all_assignments_f a
      ,      hr_soft_coding_keyflex hsc
      WHERE  a.assignment_id             = c_assignment_id
      AND    hsc.soft_coding_keyflex_id  = a.soft_coding_keyflex_id
      AND    c_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;

Line: 49

        hr_utility.set_location('Start of PER_AU_ASG_LEG_HOOK.UPDATE_AU_ASG',1);

Line: 70

         hr_utility.set_location('End of PER_AU_ASG_LEG_HOOK.UPDATE_AU_ASG',2);

Line: 75

      hr_utility.set_location('Error in PER_AU_ASG_LEG_HOOK.UPDATE_AU_ASG',100);

Line: 80

END UPDATE_AU_ASG ;