APPS.HR_DE_VALIDATE_PKG SQL Statements

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

Line: 14

	SELECT entry_information9
	FROM pay_element_entries_f entry
	WHERE entry.assignment_id = p_assignment_id
	AND p_effective_date between entry.effective_start_date and entry.effective_end_date
	AND entry.element_type_id = (SELECT element_type_id
				     FROM pay_element_types_f ele
				     WHERE p_effective_date between ele.effective_start_date and ele.effective_end_date
				     AND ele.element_name = 'Tax Information'
				     AND ele.legislation_code = 'DE')
	AND entry.entry_information_category = 'DE_TAX INFORMATION';

Line: 46

	PROCEDURE update_element_entry_validate
	(p_effective_date		IN		DATE
	,p_element_entry_id		IN		NUMBER
	,p_entry_information_category	IN		VARCHAR2
	,p_entry_information1		IN		VARCHAR2) IS

	l_table PAY_ELEMENT_ENTRIES_F.ENTRY_INFORMATION9%TYPE;

Line: 56

	SELECT assignment_id
	FROM	pay_element_entries_f ENTRY
	WHERE p_effective_date between entry.effective_start_date and entry.effective_end_date
	AND entry.element_entry_id = p_element_entry_id;

Line: 62

	SELECT entry_information9
	FROM pay_element_entries_f entry
	WHERE entry.assignment_id = l_assignment_id
	AND p_effective_date between entry.effective_start_date and entry.effective_end_date
	AND entry.element_type_id = (SELECT element_type_id
				     FROM pay_element_types_f ele
				     WHERE p_effective_date between ele.effective_start_date and ele.effective_end_date
				     AND ele.element_name = 'Tax Information'
				     AND ele.legislation_code = 'DE')
	AND entry.entry_information_category = 'DE_TAX INFORMATION';

Line: 95

	END update_element_entry_validate;