分配用人单位

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'