APPS.HXC_HAS_UPLOAD_PKG SQL Statements

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

Line: 18

	SELECT	approval_style_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_approval_style_id
	,	l_ovn
	,	l_owner
	FROM	hxc_approval_styles
	WHERE	name	= P_NAME;

Line: 30

		hxc_approval_styles_api.update_approval_styles (
				  p_approval_style_id	=> l_approval_style_id
			,	  p_name		=> p_name
			,         p_business_group_id   => null
			,         p_legislation_code    => p_legislation_code
			,	  p_description		=> p_description
	  		,	  p_object_version_number  => l_ovn );