The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
prof_area_criteria_value_id
,search_criteria_id
,professional_area
,object_version_number
from irc_prof_area_criteria_values
where prof_area_criteria_value_id = p_prof_area_criteria_value_id;
select
prof_area_criteria_value_id
,search_criteria_id
,professional_area
,object_version_number
from irc_prof_area_criteria_values
where prof_area_criteria_value_id = p_prof_area_criteria_value_id
for update nowait;