The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
layout_comp_prompt_id
,layout_component_id
,prompt_alias
,prompt_type
,region_code
,region_application_id
,attribute_code
,attribute_application_id
,object_version_number
from hxc_layout_comp_prompts
where layout_comp_prompt_id = p_layout_comp_prompt_id;
select
layout_comp_prompt_id
,layout_component_id
,prompt_alias
,prompt_type
,region_code
,region_application_id
,attribute_code
,attribute_application_id
,object_version_number
from hxc_layout_comp_prompts
where layout_comp_prompt_id = p_layout_comp_prompt_id
for update nowait;