APPS.PAY_AU_SOE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 184: (c_dimension_name pay_balance_dimensions.dimension_name%type)

180:
181: procedure populate_defined_balances
182: is
183: CURSOR c_get_defined_balance_id
184: (c_dimension_name pay_balance_dimensions.dimension_name%type)
185: IS
186: SELECT decode(pbt.balance_name, 'Earnings_Total',1
187: , 'Direct Payments',2
188: , 'Termination_Payments',3

Line 198: pay_balance_dimensions pbd,

194: , 'Earnings_Non_Taxable',9
195: , 'Total_Tax_Deductions',10) sort_index,
196: pdb.defined_balance_id defined_balance_id
197: FROM pay_balance_types pbt,
198: pay_balance_dimensions pbd,
199: pay_defined_balances pdb
200: WHERE pbt.balance_name IN ('Earnings_Total'
201: , 'Direct Payments'
202: , 'Termination_Payments'

Line 282: (c_dimension_name pay_balance_dimensions.dimension_name%type)

278:
279: /* cursor to get the defined balance ids for the various balances */
280:
281: CURSOR c_get_defined_balance_id
282: (c_dimension_name pay_balance_dimensions.dimension_name%type)
283: IS
284: SELECT decode(pbt.balance_name, 'Earnings_Total',1
285: , 'Direct Payments',2
286: , 'Termination_Payments',3

Line 296: pay_balance_dimensions pbd,

292: , 'Earnings_Non_Taxable',9
293: , 'Total_Tax_Deductions',10) sort_index,
294: pdb.defined_balance_id defined_balance_id
295: FROM pay_balance_types pbt,
296: pay_balance_dimensions pbd,
297: pay_defined_balances pdb
298: WHERE pbt.balance_name IN ('Earnings_Total'
299: , 'Direct Payments'
300: , 'Termination_Payments'

Line 339: l_bal_dimen_ytd pay_balance_dimensions.dimension_name%type ; --3935483

335: v_non_tax_allow_run number;
336: v_non_tax_allow_ytd number;
337:
338:
339: l_bal_dimen_ytd pay_balance_dimensions.dimension_name%type ; --3935483
340: l_bal_dimen_run pay_balance_dimensions.dimension_name%type ; --3935483
341:
342:
343:

Line 340: l_bal_dimen_run pay_balance_dimensions.dimension_name%type ; --3935483

336: v_non_tax_allow_ytd number;
337:
338:
339: l_bal_dimen_ytd pay_balance_dimensions.dimension_name%type ; --3935483
340: l_bal_dimen_run pay_balance_dimensions.dimension_name%type ; --3935483
341:
342:
343:
344: begin