APPS.HXC_DEP_UPLOAD_PKG SQL Statements

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

Line: 7

SELECT	time_source_id
FROM	hxc_time_sources
WHERE	name	= p_time_source;

Line: 42

	SELECT	deposit_process_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_deposit_process_id
	,	l_ovn
	,	l_owner
	FROM	hxc_deposit_processes
	WHERE	name	= P_NAME;

Line: 53

		hxc_deposit_processes_api.update_deposit_processes (
				  p_effective_date         => sysdate
	  		,	  p_name                   => p_name
	  		,	  p_time_source_id         => l_time_source_id
	  		,	  p_mapping_id             => l_mapping_id
	  		,	  p_deposit_process_id     => l_deposit_process_id
	  		,	  p_object_version_number  => l_ovn );