APPS.HXC_HTS_UPLOAD_PKG SQL Statements

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

Line: 15

	SELECT	time_source_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_time_source_id
	,	l_ovn
	,	l_owner
	FROM	hxc_time_sources
	WHERE	name	= P_NAME;

Line: 39

	,p_last_update_date         IN VARCHAR2) IS

l_time_source_id	hxc_time_sources.time_source_id%TYPE;

Line: 47

	SELECT	time_source_id
	,	object_version_number

	INTO	l_time_source_id
	,	l_ovn

	FROM	hxc_time_sources
	WHERE	name	= P_NAME;