APPS.HXC_HAC_UPLOAD_PKG SQL Statements

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

Line: 28

SELECT	approval_style_id
FROM	hxc_approval_styles
WHERE	name	= p_name;

Line: 47

SELECT	ff.formula_id
FROM	ff_formulas_f ff
WHERE	ff.formula_name = p_formula_name;

Line: 75

	SELECT	hac.approval_comp_id
	,	hac.object_version_number
	,	DECODE( NVL(hac.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_approval_comp_id
	,	l_ovn
	,	l_owner
	FROM	hxc_approval_comps hac
	,	hxc_approval_styles has
	WHERE	has.name	= P_AS_NAME
	AND	hac.approval_style_id = has.approval_style_id
	AND	hac.time_recipient_id = l_time_recipient_id
	AND	hac.approval_mechanism = p_approval_mechanism;