DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_BALANCE_DIMENSIONS

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

156: -- Description : To get the YTD defined balance ids for the balances
157: -- Earnings_Standard and Pre Tax Deductions
158: --
159: -----------------------------------------------------------------------
160: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
161: IS
162: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
163: FROM pay_balance_types pbt,
164: pay_balance_dimensions pbd,

Line 164: pay_balance_dimensions pbd,

160: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
161: IS
162: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
163: FROM pay_balance_types pbt,
164: pay_balance_dimensions pbd,
165: pay_defined_balances pdb
166: WHERE pbt.balance_name in ( 'Earnings_Standard'
167: ,'Pre Tax Spread Deductions'
168: ,'Pre Tax Fixed Deductions' /*bug4363057*/