The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
gap_absence_plan_id
,assignment_id
,absence_attendance_id
,pl_id
,last_gap_daily_absence_date
,object_version_number
from pqp_gap_absence_plans
where gap_absence_plan_id = p_gap_absence_plan_id;
select
gap_absence_plan_id
,assignment_id
,absence_attendance_id
,pl_id
,last_gap_daily_absence_date
,object_version_number
from pqp_gap_absence_plans
where gap_absence_plan_id = p_gap_absence_plan_id
for update nowait;