APPS.HXC_APC_UPLOAD_PKG SQL Statements

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

Line: 10

SELECT	approval_period_set_id
FROM	hxc_approval_period_sets
WHERE	name = p_approval_period_set_name;

Line: 29

SELECT	time_recipient_id
FROM	hxc_time_recipients
WHERE	name = p_name;

Line: 48

SELECT	recurring_period_id
FROM	hxc_recurring_periods
WHERE	name = p_name;

Line: 98

	SELECT	sc.approval_period_comp_id
	,	sc.object_version_number
	,	DECODE( NVL( sc.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_approval_period_comp_id
	,	l_ovn
	,	l_owner
	FROM	hxc_approval_period_sets aps
	,	hxc_approval_period_comps_v sc
	WHERE	sc.time_recipient_id    	= l_time_recipient_id
        AND     sc.recurring_period_id          = l_recurring_period_id
	AND     sc.approval_period_set_id	= aps.approval_period_set_id
	AND	aps.approval_period_set_id      = l_approval_period_set_id;