APPS.HXC_REC_PERIODS_UPLOAD_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

	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;

Line: 29

           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
               );