The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT recurring_period_id
,object_version_number
,DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
INTO l_recurring_period_id
,l_ovn
,l_owner
FROM hxc_recurring_periods
WHERE name = p_name;
hxc_recurring_periods_api.update_recurring_periods
(p_validate => false
,p_recurring_period_id => l_recurring_period_id
,p_object_version_number => l_ovn
,p_name => p_name
,p_period_type => p_period_type
,p_duration_in_days => p_duration_in_days
,p_start_date => to_date(p_start_date, 'DD-MM-YYYY')
,p_end_date => to_date(p_end_date, 'DD-MM-YYYY')
,p_effective_date => sysdate
);