The following lines contain the word 'select', 'insert', 'update' or 'delete':
select element_entry_value_id
from pay_element_entry_values_f
where element_entry_id = p_element_entry_id
and input_value_id = p_input_value_id
and p_effective_date between effective_start_date
and effective_end_date;
ben_prtt_rt_val_api.update_prtt_rt_val
(p_validate => false
,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
,p_business_group_id => l_prv.business_group_id
,p_element_entry_value_id => l_element_entry_value_id
,p_object_version_number => l_prv.object_version_number
,p_effective_date => l_prv.rt_strt_dt
);
end update_element_entry_value;