DBA Data[Home] [Help]

APPS.PAY_US_DEF_COMP_457 dependencies on PAY_BALANCE_TYPES

Line 432: FROM pay_balance_types pbt ,

428: AND p_balance_name <> 'Calc 457 Limit') THEN
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

Line 444: FROM pay_balance_types pbt ,

440: ELSE
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