The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into pay_balance_dimensions
(balance_dimension_id,
business_group_id,
legislation_code,
route_id,
payments_flag,
database_item_suffix,
dimension_name,
dimension_type,
description,
feed_checking_code,
feed_checking_type,
expiry_checking_code,
expiry_checking_level,
dimension_level,
period_type,
asg_action_balance_dim_id,
database_item_function,
save_run_balance_enabled,
start_date_code)
select pay_balance_dimensions_s.nextval,
p_business_group_id,
p_legislation_code,
p_route_id,
p_payments_flag,
p_database_item_suffix,
p_dimension_name,
p_dimension_type,
p_description,
p_feed_checking_code,
p_feed_checking_type,
p_expiry_checking_code,
p_expiry_checking_level,
p_dimension_level,
p_period_type,
p_asg_bal_dim,
p_dbi_function,
p_save_run_balance_enabled,
p_start_date_code
from dual
where not exists (select ''
from pay_balance_dimensions
where dimension_name = p_dimension_name
and nvl(business_group_id, -999) =
nvl(p_business_group_id, -999)
and nvl(legislation_code, 'NULL') =
nvl(p_legislation_code, 'NULL')
);
select pay_balance_dimensions_s.currval
into x from dual;
insert into pay_dimension_routes
(balance_dimension_id,
route_id,
route_type,
run_dimension_id,
priority,
balance_type_column,
decode_required
)
select p_dim_id,
p_route_id,
p_route_type,
p_run_dim_id,
p_priority,
p_baltyp_col,
p_dec_required
from sys.dual
where not exists (select ''
from pay_dimension_routes
where balance_dimension_id = p_dim_id
and route_type = p_route_type
and priority = p_priority);