The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
cagr_retained_right_id
,assignment_id
,cagr_entitlement_item_id
,collective_agreement_id
,cagr_entitlement_id
,category_name
,element_type_id
,input_value_id
,cagr_api_id
,cagr_api_param_id
,cagr_entitlement_line_id
,freeze_flag
,value
,units_of_measure
,start_date
,end_date
,parent_spine_id
,formula_id
,oipl_id
,step_id
,grade_spine_id
,column_type
,column_size
,eligy_prfl_id
,object_version_number
,cagr_entitlement_result_id
,business_group_id
,flex_value_set_id
from per_cagr_retained_rights
where cagr_retained_right_id = p_cagr_retained_right_id;
select
cagr_retained_right_id
,assignment_id
,cagr_entitlement_item_id
,collective_agreement_id
,cagr_entitlement_id
,category_name
,element_type_id
,input_value_id
,cagr_api_id
,cagr_api_param_id
,cagr_entitlement_line_id
,freeze_flag
,value
,units_of_measure
,start_date
,end_date
,parent_spine_id
,formula_id
,oipl_id
,step_id
,grade_spine_id
,column_type
,column_size
,eligy_prfl_id
,object_version_number
,cagr_entitlement_result_id
,business_group_id
,flex_value_set_id
from per_cagr_retained_rights
where cagr_retained_right_id = p_cagr_retained_right_id
for update nowait;