The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
item_property_id
,language
,source_lang
,default_value
,information_prompt
,label
,prompt_text
,tooltip_text
from hr_item_properties_tl
where item_property_id = p_item_property_id
and language = p_language;
select
item_property_id
,language
,source_lang
,default_value
,information_prompt
,label
,prompt_text
,tooltip_text
from hr_item_properties_tl
where item_property_id = p_item_property_id
and language = p_language
for update nowait;
select ipt.item_property_id
,ipt.default_value
,ipt.information_prompt
,ipt.label
,ipt.prompt_text
,ipt.tooltip_text
,ipt.source_lang
from hr_item_properties_tl ipt
where ipt.language = userenv('LANG');