DBA Data[Home] [Help]

APPS.HXC_APR_UPLOAD_PKG SQL Statements

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

Line: 15

	SELECT	approval_period_set_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_approval_period_set_id
	,	l_ovn
	,	l_owner
	FROM	hxc_approval_period_sets
	WHERE	name	= P_APPROVAL_PERIOD_SET_NAME;