The following lines contain the word 'select', 'insert', 'update' or 'delete':
select piv.input_value_id
from pay_input_values_f piv,
pay_element_types_f petf
where petf.element_type_id = piv.element_type_id
and petf.element_name = 'Working Tax Credit'
and piv.name = 'Daily Amount'
and petf.legislation_code = 'GB';
select peef.effective_start_date as start_date,
peef.effective_end_date as end_date,
max(decode(peev.input_value_id,l_daily_amt_iv_id,
fnd_number.canonical_to_number(peev.Screen_entry_value),null)) as daily_amount
from pay_element_entry_values_f peev,
pay_element_entries_f peef,
pay_element_links_f pelf,
pay_element_types_f petf
where pelf.element_link_id = peef.element_link_id
and peef.element_entry_id = peev.element_entry_id
and petf.element_type_id = pelf.element_type_id
and peev.effective_start_date = peef.effective_start_date
and upper(petf.element_name) = upper('Working Tax Credit')
and petf.legislation_code = 'GB'
and peef.assignment_id = p_assignment_id
and peef.effective_start_date <= p_end_date
and ( peef.effective_start_date >= p_start_date
OR (peef.effective_start_date <= p_start_date
AND peef.effective_end_date >= p_start_date)
)
and peef.entry_type = 'E'
group by peef.effective_start_date, peef.effective_end_date;