DBA Data[Home] [Help]

APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on FF_ROUTE_PARAMETERS

Line 247: ,ff_route_parameters rp

243: CURSOR csr_get_dbi_user_name (c_bal_type_id NUMBER) IS
244: SELECT user_name
245: FROM ff_database_items dbi
246: ,ff_route_parameter_values rpv
247: ,ff_route_parameters rp
248: ,pay_balance_dimensions pbd
249: ,pay_defined_balances pdb
250: WHERE dbi.user_entity_id = rpv.user_entity_id
251: AND rpv.route_parameter_id = rp.route_parameter_id

Line 263: ,ff_route_parameters rp

259: CURSOR csr_get_dbi_asg_user_name (c_bal_type_id NUMBER) IS
260: SELECT user_name
261: FROM ff_database_items dbi
262: ,ff_route_parameter_values rpv
263: ,ff_route_parameters rp
264: ,pay_balance_dimensions pbd
265: ,pay_defined_balances pdb
266: WHERE dbi.user_entity_id = rpv.user_entity_id -- 4472436
267: AND rpv.route_parameter_id = rp.route_parameter_id -- 1999