DBA Data[Home] [Help]

APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_DEFINED_BALANCES

Line 249: ,pay_defined_balances pdb

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
252: AND rp.route_id = pbd.route_id
253: AND pbd.database_item_suffix = '_PER_YTD' -- nilesh

Line 265: ,pay_defined_balances pdb

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
268: AND rp.route_id = pbd.route_id
269: AND pbd.database_item_suffix = '_ASG_RUN' -- nilesh