APPS.PAY_CA_VAC_BANK SQL Statements

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

Line: 20

  SELECT TRUNC(MONTHS_BETWEEN(p_date_earned, pds.date_start)/12)
  FROM   per_all_assignments_f   asg,
         per_periods_of_service  pds
  WHERE  asg.assignment_id = p_assignment_id
  AND    p_date_earned BETWEEN asg.effective_start_date
                           AND asg.effective_end_date
  AND    pds.person_id     = asg.person_id;