APPS.HXC_RRC_UPLOAD_PKG SQL Statements

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

Line: 9

SELECT	retrieval_rule_group_id
FROM	hxc_retrieval_rule_groups_v
WHERE	retrieval_rule_group_name = p_retrieval_rule_group_name;

Line: 28

SELECT	retrieval_rule_id
FROM	hxc_retrieval_rules
WHERE	name = p_name;

Line: 77

	SELECT	rrc.retrieval_rule_group_comp_id
	,	rrc.object_version_number
	,	DECODE( NVL( rrc.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_rtr_group_comp_id
	,	l_ovn
	,	l_owner
	FROM	hxc_retrieval_rule_groups_v rrg
	,	hxc_retrieval_rule_grp_comps_v rrc
	WHERE	rrc.retrieval_rule_id    	= l_retrieval_rule_id
	AND     rrc.retrieval_rule_group_id	= rrg.retrieval_rule_group_id
	AND	rrg.retrieval_rule_group_id     = l_retrieval_rule_group_id;