APPS.HXC_TER_UPLOAD_PKG SQL Statements

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

Line: 63

SELECT	formula_id
FROM	ff_formulas_f ff
WHERE   ff.formula_name	= p_formula_name
AND	TO_DATE(p_start_date, 'DD-MM-YYYY') BETWEEN ff.effective_start_date AND ff.effective_end_date;

Line: 85

SELECT tr.time_recipient_id
FROM   hxc_time_recipients tr
WHERE  tr.name = p_time_recipient_name;

Line: 104

SELECT htc.time_category_id
FROM   hxc_time_categories htc
WHERE  htc.time_category_name = p_time_category_name;

Line: 153

	SELECT	time_entry_rule_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_time_entry_rule_id
	,	l_ovn
	,	l_owner
	FROM	hxc_time_entry_rules
	WHERE	name	= P_NAME;

Line: 172

		hxc_time_entry_rule_api.update_time_entry_rule (
				  p_effective_date         => to_date(p_start_date, 'DD-MM-YYYY')
			,	  p_time_entry_rule_id  => l_time_entry_rule_id
			,	  p_name                   => p_name
			,         p_business_group_id      => null
			,         p_legislation_code       => p_legislation_code
			,	  p_rule_usage             => p_rule_usage
			,	  p_start_date             => to_date(p_start_date, 'DD-MM-YYYY')
			,	  p_mapping_id             => l_mapping_id
			,	  p_formula_id             => l_formula_id
			,	  p_description            => p_description
			,	  p_end_date               => to_date(p_end_date, 'DD-MM-YYYY')
			,	  p_attribute_category	   => l_attribute_category
			,	  p_attribute1		   => l_attribute1
			,	  p_attribute2		   => l_attribute2
			,	  p_attribute3		   => p_attribute3
			,	  p_attribute4		   => p_attribute4
			,	  p_attribute5		   => p_attribute5
			,	  p_attribute6		   => p_attribute6
			,	  p_attribute7		   => p_attribute7
			,	  p_attribute8		   => p_attribute8
			,	  p_attribute9		   => p_attribute9
			,	  p_attribute10		   => p_attribute10
			,	  p_attribute11 	   => p_attribute11
			,	  p_attribute12		   => p_attribute12
			,	  p_attribute13		   => p_attribute13
			,	  p_attribute14		   => p_attribute14
			,	  p_attribute15		   => p_attribute15
			,	  p_attribute16		   => p_attribute16
			,	  p_attribute17		   => p_attribute17
			,	  p_attribute18		   => p_attribute18
			,	  p_attribute19		   => p_attribute19
			,	  p_attribute20		   => p_attribute20
			,	  p_attribute21		   => p_attribute21
			,	  p_attribute22		   => p_attribute22
			,	  p_attribute23		   => p_attribute23
			,	  p_attribute24		   => p_attribute24
			,	  p_attribute25		   => p_attribute25
			,	  p_attribute26		   => p_attribute26
			,	  p_attribute27		   => p_attribute27
			,	  p_attribute28		   => p_attribute28
			,	  p_attribute29		   => p_attribute29
			,	  p_attribute30		   => p_attribute30
	  		,	  p_object_version_number  => l_ovn );

Line: 289

SELECT	time_entry_rule_id
FROM	hxc_time_entry_rules
WHERE	name 	= p_time_entry_rule_name;

Line: 310

SELECT	approval_style_id
FROM	hxc_approval_styles
WHERE	name	= p_approval_style_name;

Line: 332

	SELECT	data_app_rule_usage_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_data_app_rule_usage_id
	,	l_ovn
	,	l_owner
	FROM	hxc_data_app_rule_usages
	WHERE	time_entry_rule_id	= l_time_entry_rule_id
	AND	approval_style_id	= l_approval_style_id;

Line: 345

		hxc_data_app_rule_usages_api.update_data_app_rule_usages (
				  p_effective_date		=> sysdate
			,	  p_approval_style_id		=> l_approval_style_id
			,	  p_time_entry_rule_id          => l_time_entry_rule_id
			,	  p_time_recipient_id           => l_time_recipient_id
			,	  p_data_app_rule_usage_id      => l_data_app_rule_usage_id
	  		,	  p_object_version_number	=> l_ovn );