select b.defined_balance_id,
bttl.balance_type_id,
bttl.balance_name,
b.dimension_name,
b.dimension_description
from pay_defined_balances_v2 b,
pay_balance_types bt,
pay_balance_types_tl bttl
where b.defined_balance_id in
(select u.value
from ff_route_parameters p,
ff_user_entities e,
ff_database_items d,
ff_route_parameter_values u
where p.route_id = e.route_id
and e.user_entity_id = d.user_entity_id
and d.user_name like '%PHF_SI_EMPLOYEE_DEDUCTIONS_ASG_ER_RUN%'
and p.route_parameter_id = u.route_parameter_id
and e.user_entity_id = u.user_entity_id)
and b.balance_type_id = bt.balance_type_id
and bt.balance_type_id = bttl.balance_type_id
and bttl.language = 'ZHS'
bttl.balance_type_id,
bttl.balance_name,
b.dimension_name,
b.dimension_description
from pay_defined_balances_v2 b,
pay_balance_types bt,
pay_balance_types_tl bttl
where b.defined_balance_id in
(select u.value
from ff_route_parameters p,
ff_user_entities e,
ff_database_items d,
ff_route_parameter_values u
where p.route_id = e.route_id
and e.user_entity_id = d.user_entity_id
and d.user_name like '%PHF_SI_EMPLOYEE_DEDUCTIONS_ASG_ER_RUN%'
and p.route_parameter_id = u.route_parameter_id
and e.user_entity_id = u.user_entity_id)
and b.balance_type_id = bt.balance_type_id
and bt.balance_type_id = bttl.balance_type_id
and bttl.language = 'ZHS'