The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
location_criteria_value_id
,search_criteria_id
,derived_locale
,object_version_number
from irc_location_criteria_values
where location_criteria_value_id = p_location_criteria_value_id;
select
location_criteria_value_id
,search_criteria_id
,derived_locale
,object_version_number
from irc_location_criteria_values
where location_criteria_value_id = p_location_criteria_value_id
for update nowait;