The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_absences_taken.DELETE;
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 ;