The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
cagr_api_param_id
,cagr_api_id
,display_name
,parameter_name
,column_type
,column_size
,uom_parameter
,uom_lookup
,default_uom
,hidden
,object_version_number
from per_cagr_api_parameters
where cagr_api_param_id = p_cagr_api_param_id;
select
cagr_api_param_id
,cagr_api_id
,display_name
,parameter_name
,column_type
,column_size
,uom_parameter
,uom_lookup
,default_uom
,hidden
,object_version_number
from per_cagr_api_parameters
where cagr_api_param_id = p_cagr_api_param_id
for update nowait;