The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT peef.element_entry_id,
decode(peef.entry_information1
,'P1',1000
,'P2',2000
,'P3',3000,9000) garn_priority
FROM pay_element_entries_f peef
,pay_element_classifications pec
,pay_element_types_f petf
,pay_element_links_f pelf
WHERE peef.assignment_id = p_assignment_id
AND trunc(p_earned_date) between trunc(peef.effective_start_date)
and
trunc(peef.effective_end_date)
AND peef.element_link_id = pelf.element_link_id
AND trunc(p_earned_date) between trunc(pelf.effective_start_date)
and
trunc(pelf.effective_end_date)
AND pelf.element_type_id = petf.element_type_id
AND trunc(p_earned_date) between trunc(petf.effective_start_date)
and
trunc(petf.effective_end_date)
AND petf.classification_id = pec.classification_id
AND pec.classification_name like 'Involuntary Deductions'
ORDER BY decode(peef.entry_information1
,'P1',1000
,'P2',2000
,'P3',3000,9000),
decode(peef.entry_information3
,'ORDER',1
,'EQUAL',2
,'PROPORTION',2,9),
peef.entry_information4;