The following lines contain the word 'select', 'insert', 'update' or 'delete':
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';
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;
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;
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';
END update_element_entry_validate;