The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'Y'
from pay_accrual_bands
where (p_lower_limit between lower_limit and upper_limit
or
p_upper_limit between lower_limit and upper_limit
or
lower_limit between p_lower_limit and p_upper_limit
or
upper_limit between p_lower_limit and p_upper_limit)
and ((p_accrual_band_id is null)
or (p_accrual_band_id is not null
and accrual_band_id <> p_accrual_band_id))
and accrual_plan_id = p_accrual_plan_id;
select 'Y'
from pay_accrual_bands
where accrual_plan_id = p_accrual_plan_id
and (p_accrual_band_id is null
or p_accrual_band_id is not null
and accrual_band_id <> p_accrual_band_id)
and ((p_ceiling is null
and ceiling is not null)
or (p_ceiling is not null
and ceiling is null));