The following lines contain the word 'select', 'insert', 'update' or 'delete':
select unique_key_id
into l_id
from hr_pump_batch_line_user_keys
where user_key_value = p_user_key_value;
select balance_category_id
into l_balance_category_id
from pay_balance_categories_f
where category_name = p_category_name
and nvl(business_group_id, nvl(p_business_group_id,-1))
= nvl(p_business_group_id,-1)
and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
= nvl(hr_api.return_legislation_code(p_business_group_id),' ')
and p_effective_date between effective_start_date
and effective_end_date;
select balance_type_id
into l_balance_type_id
from pay_balance_types
where base_balance_type_id is null
and balance_name = p_base_balance_name
and nvl(business_group_id, nvl(p_business_group_id,-1))
= nvl(p_business_group_id,-1)
and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
= nvl(hr_api.return_legislation_code(p_business_group_id),' ');
select blt.object_version_number
into l_blt_ovn
from pay_balance_types blt,
hr_pump_batch_line_user_keys key
where key.user_key_value = p_balance_type_user_key
and blt.balance_type_id = key.unique_key_id;