The following lines contain the word 'select', 'insert', 'update' or 'delete':
select full_item_name
into l_return
from hr_form_items_b
where form_item_id = p_item_id
and application_id = p_application_id
and form_id = p_form_id;
select formula_name
into l_return
from ff_formulas_f
where formula_id = p_formula_id
and sysdate between effective_start_date and effective_end_date;
SELECT
ff.formula_name
FROM
pay_status_processing_rules_f pspr,
ff_formulas_f ff
WHERE
pspr.element_type_id = p_element_type_id AND
p_effective_date BETWEEN pspr.effective_start_date AND
pspr.effective_end_date AND
pspr.formula_id = ff.formula_id AND
p_effective_date BETWEEN ff.effective_start_date AND
ff.effective_end_date;
select legislation_code
into l_leg_code
from ff_formulas_f
where formula_id = p_formula_id
and sysdate between effective_start_date and effective_end_date;
select territory_short_name
into l_return
from fnd_territories_vl
where territory_code = l_leg_code;
select business_group_id
into l_bus_group_id
from ff_formulas_f
where formula_id = p_formula_id
and sysdate between effective_start_date and effective_end_date;
select name
into l_return
from per_business_groups
where business_group_id = l_bus_group_id;
select tab_page_name
into l_return
from hr_form_tab_pages_b
where form_tab_page_id = p_form_tab_page_id
and form_canvas_id = p_form_canvas_id;
select template_name
into l_return
from hr_form_templates_b
where form_template_id = p_form_template_id;
select application_short_name
into l_return
from hr_form_templates_b hft,
fnd_application fa
where hft.form_template_id = p_form_template_id
and fa.application_id = hft.application_id;
select form_name
into l_return
from hr_form_templates_b hft,
fnd_form ff
where hft.form_template_id = p_form_template_id
and ff.application_id = hft.application_id
and ff.form_id = hft.form_id;
IS SELECT
bcf.category_name
FROM
pay_balance_categories_f bcf
WHERE
bcf.balance_category_id = p_category_id AND
SYSDATE BETWEEN bcf.effective_start_date AND
bcf.effective_end_date;