The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
profile_snapshot_id
,person_id
,object_version_number
from irc_apl_profile_snapshots
where profile_snapshot_id = p_profile_snapshot_id;
select
profile_snapshot_id
,person_id
,object_version_number
from irc_apl_profile_snapshots
where profile_snapshot_id = p_profile_snapshot_id
for update nowait;