DBA Data[Home] [Help]

APPS.PAY_US_DEF_COMP_457 dependencies on PAY_DEFINED_BALANCES

Line 433: pay_defined_balances pdb ,

429: SELECT /*+ USE_NL (pbd) */
430: pdb.defined_balance_id
431: INTO l_defined_balance_id
432: FROM pay_balance_types pbt ,
433: pay_defined_balances pdb ,
434: pay_balance_dimensions pbd
435: WHERE pbt.balance_name = p_balance_name
436: AND pbt.balance_type_id = pdb.balance_type_id
437: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 445: pay_defined_balances pdb ,

441: SELECT /*+ USE_NL (pbd) */
442: pdb.defined_balance_id
443: INTO l_defined_balance_id
444: FROM pay_balance_types pbt ,
445: pay_defined_balances pdb ,
446: pay_balance_dimensions pbd
447: WHERE pbt.balance_name = p_balance_name
448: AND pbt.balance_type_id = pdb.balance_type_id
449: AND pbd.balance_dimension_id = pdb.balance_dimension_id