DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 310: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)

306: -- Earnings_Total
307: -- Earnings_Non_Taxable
308: -- Lump Sum E Payments
309: -----------------------------------------------------------------------
310: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
311: IS
312: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
313: FROM pay_balance_types pbt,
314: pay_balance_dimensions pbd,

Line 314: pay_balance_dimensions pbd,

310: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
311: IS
312: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
313: FROM pay_balance_types pbt,
314: pay_balance_dimensions pbd,
315: pay_defined_balances pdb
316: WHERE pbt.balance_name in ( 'Earnings_Standard'
317: ,'Pre Tax Spread Deductions'
318: ,'Pre Tax Fixed Deductions' /*bug 4474896*/