The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
accrual_plan_id,
business_group_id,
accrual_plan_element_type_id,
pto_input_value_id,
co_input_value_id,
residual_input_value_id,
accrual_category,
accrual_plan_name,
accrual_start,
accrual_units_of_measure,
ineligible_period_length,
ineligible_period_type,
accrual_formula_id,
co_formula_id,
co_date_input_value_id,
co_exp_date_input_value_id,
residual_date_input_value_id,
description,
ineligibility_formula_id,
payroll_formula_id,
defined_balance_id,
tagging_element_type_id,
balance_element_type_id,
object_version_number,
information_category,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12,
information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20,
information21,
information22,
information23,
information24,
information25,
information26,
information27,
information28,
information29,
information30
from pay_accrual_plans
where accrual_plan_id = p_accrual_plan_id;
select accrual_plan_id,
business_group_id,
accrual_plan_element_type_id,
pto_input_value_id,
co_input_value_id,
residual_input_value_id,
accrual_category,
accrual_plan_name,
accrual_start,
accrual_units_of_measure,
ineligible_period_length,
ineligible_period_type,
accrual_formula_id,
co_formula_id,
co_date_input_value_id,
co_exp_date_input_value_id,
residual_date_input_value_id,
description,
ineligibility_formula_id,
payroll_formula_id,
defined_balance_id,
tagging_element_type_id,
balance_element_type_id,
object_version_number,
information_category,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12,
information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20,
information21,
information22,
information23,
information24,
information25,
information26,
information27,
information28,
information29,
information30
from pay_accrual_plans
where accrual_plan_id = p_accrual_plan_id
for update nowait;