DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_BALANCE_DIMENSIONS

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

182: -- Description : To get the YTD defined balance ids for the balances
183: -- Earnings_Standard and Pre Tax Deductions
184: --
185: -----------------------------------------------------------------------
186: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
187: IS
188: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
189: FROM pay_balance_types pbt,
190: pay_balance_dimensions pbd,

Line 190: pay_balance_dimensions pbd,

186: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
187: IS
188: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
189: FROM pay_balance_types pbt,
190: pay_balance_dimensions pbd,
191: pay_defined_balances pdb
192: WHERE pbt.balance_name in ( 'Earnings_Standard'
193: ,'Pre Tax Spread Deductions'
194: ,'Pre Tax Fixed Deductions' /*bug4363057*/