The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM pay_element_entries_f pee
WHERE pee.element_link_id = p_element_link_id
AND pee.assignment_id = p_assignment_id
AND p_effective_date between pee.effective_start_date
and pee.effective_end_date;
select *
into g_line_record
from pay_batch_lines
where batch_line_id = p_batch_line_id;
select *
into g_header_record
from pay_batch_headers
where batch_id = g_line_record.batch_id;
select elt.element_name
into l_element_name
from pay_element_types_f elt
where elt.element_type_id = g_line_record.element_type_id
and (elt.business_group_id +0 = g_header_record.business_group_id
or (elt.business_group_id is null
and elt.legislation_code = 'US'))
and g_line_record.effective_date between elt.effective_start_date
and elt.effective_end_date;
select element_type_id
into l_base_element_type_id
from pay_element_types_f pet
where pet.element_name = l_base_element_name
and pet.processing_type = 'R'
and (pet.business_group_id = g_header_record.business_group_id
or (pet.business_group_id IS NULL
and pet.legislation_code = 'US'))
and g_line_record.effective_date between pet.effective_start_date
and pet.effective_end_date;