APPS.HXC_MCU_UPLOAD_PKG SQL Statements

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

Line: 7

SELECT	mapping_id
FROM	hxc_mappings
WHERE	name = p_mapping_name;

Line: 26

SELECT	mapping_component_id
FROM	hxc_mapping_components
WHERE	name = p_name;

Line: 61

	SELECT	mcu.mapping_comp_usage_id
	,	mcu.object_version_number
	,	DECODE( NVL( mcu.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_mapping_comp_usage_id
	,	l_ovn
	,	l_owner
	FROM	hxc_mapping_comp_usages mcu
	,	hxc_mapping_components mpc
	WHERE	mpc.name	= P_NAME
	AND	mcu.mapping_component_id = mpc.mapping_component_id
	AND	mcu.mapping_id		 = l_mapping_id;