APPS.HXC_HRR_UPLOAD_PKG SQL Statements

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

Line: 26

SELECT	pref_hierarchy_id
FROM	hxc_pref_hierarchies
WHERE	name	= p_name
AND	parent_pref_hierarchy_id is null;

Line: 46

	SELECT	resource_rule_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_resource_rule_id
	,	l_ovn
	,	l_owner
	FROM	hxc_resource_rules
	WHERE	name	= P_NAME;

Line: 58

		hxc_resource_rules_api.update_resource_rules (
				  p_effective_date		=> sysdate
				, p_name			=> p_name
				, p_business_group_id           => null
				, p_legislation_code            => p_legislation_code
				, p_resource_rule_id		=> l_resource_rule_id
				, p_eligibility_criteria_type   => p_eligibility_criteria_type
				, p_pref_hierarchy_id           => l_pref_hierarchy_id
				, p_rule_evaluation_order       => p_rule_evaluation_order
				, p_resource_type               => p_resource_type
				, p_start_date                  => TO_DATE(p_start_date, 'DD-MM-YYYY')
				, p_end_date                    => TO_DATE(p_end_date, 'DD-MM-YYYY')
	  			, p_object_version_number  	=> l_ovn );