The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
pil_assignment_id
,per_in_ler_id
,applicant_assignment_id
,offer_assignment_id
,object_version_number
from ben_pil_assignment
where pil_assignment_id = p_pil_assignment_id;
select
pil_assignment_id
,per_in_ler_id
,applicant_assignment_id
,offer_assignment_id
,object_version_number
from ben_pil_assignment
where pil_assignment_id = p_pil_assignment_id
for update nowait;