199:
200: CURSOR csr_get_dbi_user_name (c_bal_type_id NUMBER) IS
201: SELECT user_name
202: FROM ff_database_items dbi
203: ,ff_route_parameter_values rpv
204: ,ff_route_parameters rp
205: ,pay_balance_dimensions pbd
206: ,pay_defined_balances pdb
207: WHERE dbi.user_entity_id = rpv.user_entity_id
217: -- Pension Salary Balance for ABP
218: CURSOR csr_get_pen_sal_bal_dbi_name (c_bal_type_id NUMBER) IS
219: SELECT user_name
220: FROM ff_database_items dbi
221: ,ff_route_parameter_values rpv
222: ,ff_route_parameters rp
223: ,pay_balance_dimensions pbd
224: ,pay_defined_balances pdb
225: WHERE dbi.user_entity_id = rpv.user_entity_id