The following lines contain the word 'select', 'insert', 'update' or 'delete':
select bt.balance_type_id
into l_balance_type_id
from pay_balance_types bt, pay_balance_types_tl bttl
where bt.balance_type_id = bttl.balance_type_id
and bttl.language = p_language_code
and bttl.balance_name = p_balance_name
and (nvl(bt.business_group_id,-1) = p_business_group_id
or nvl(bt.legislation_code,' ') =
hr_api.return_legislation_code(p_business_group_id)
or bt.business_group_id is null
and bt.legislation_code is null);
select pbf.object_version_number
into l_balance_feed_ovn
from pay_balance_feeds_f pbf,
hr_pump_batch_line_user_keys key
where key.user_key_value = p_balance_feed_user_key
and pbf.balance_feed_id = key.unique_key_id
and p_effective_date between pbf.effective_start_date
and pbf.effective_end_date;