DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PAY_BALANCE_DIMENSIONS

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

321: -- Earnings_Total
322: -- Earnings_Non_Taxable
323: -- Lump Sum E Payments
324: -----------------------------------------------------------------------
325: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
326: IS
327: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
328: FROM pay_balance_types pbt,
329: pay_balance_dimensions pbd,

Line 329: pay_balance_dimensions pbd,

325: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
326: IS
327: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
328: FROM pay_balance_types pbt,
329: pay_balance_dimensions pbd,
330: pay_defined_balances pdb
331: WHERE pbt.balance_name in ( 'Earnings_Standard'
332: ,'Pre Tax Spread Deductions'
333: ,'Pre Tax Fixed Deductions' /*bug 4474896*/