The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
occupation_id,
business_group_id,
rate_id,
job_id,
comments,
object_version_number
from pay_wci_occupations
where occupation_id = p_occupation_id;
select occupation_id,
business_group_id,
rate_id,
job_id,
comments,
object_version_number
from pay_wci_occupations
where occupation_id = p_occupation_id
for update nowait;