APPS.HXC_ASC_UPLOAD_PKG SQL Statements

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

Line: 9

SELECT	application_set_id
FROM	hxc_application_sets_v
WHERE	application_set_name = p_application_set_name;

Line: 28

SELECT	time_recipient_id
FROM	hxc_time_recipients
WHERE	name = p_name;

Line: 75

	SELECT	sc.application_set_comp_id
	,	sc.object_version_number
	,	DECODE( NVL( sc.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_application_set_comp_id
	,	l_ovn
	,	l_owner
	FROM	hxc_application_sets_v aps
	,	hxc_application_set_comps_v sc
	WHERE	sc.time_recipient_id	= l_time_recipient_id
	AND	aps.application_set_id	= sc.application_set_id
	AND	aps.application_set_id  = l_application_set_id;