APPS.HXC_RET_UPLOAD_PKG SQL Statements

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

Line: 7

SELECT	time_recipient_id
FROM	hxc_time_recipients
WHERE	name	= p_time_recipient;

Line: 42

	SELECT	retrieval_process_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_retrieval_process_id
	,	l_ovn
	,	l_owner
	FROM	hxc_retrieval_processes
	WHERE	name	= P_NAME;

Line: 54

	hxc_retrieval_processes_api.update_retrieval_processes (
	  			  p_name                   => p_name
	  		,	  p_time_recipient_id      => l_time_recipient_id
	  		,	  p_mapping_id             => l_mapping_id
	  		,	  p_retrieval_process_id   => l_retrieval_process_id
	  		,	  p_object_version_number  => l_ovn );