APPS.PQP_GB_CSS_DAILY_ABSENCES SQL Statements

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

Line: 542

         l_absences_taken.DELETE;

Line: 914

  select NVL(SUM(gda.duration),0)
  from  pqp_gap_daily_absences gda
       ,pqp_gap_absence_plans gap
       ,ben_pl_f pl
  where pl.pl_id = gap.pl_id
    and pl.pl_typ_id = p_pl_typ_id
    and gap.gap_absence_plan_id = gda.gap_absence_plan_id
    and gap.assignment_id = p_assignment_id
    and gda.level_of_pay = 'NOBAND'
    and gda.absence_date between p_rolling_start_date
                           and   p_rolling_end_date ;