APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_BALANCE_DIMENSIONS

Line 293: pay_balance_dimensions pbd,

289: ) sort_index,
290: pdb.defined_balance_id defined_balance_id,
291: pbt.balance_name
292: FROM pay_balance_types pbt,
293: pay_balance_dimensions pbd,
294: pay_defined_balances pdb
295: WHERE pbt.balance_name IN ('Earnings_Total','Direct Payments','Termination_Payments','Involuntary Deductions',
296: 'Pre Tax Deductions','Termination Deductions','Voluntary Deductions','Total_Tax_Deductions',
297: 'Earnings_Non_Taxable','Employer_Charges','Lump Sum A Payments','Lump Sum B Payments','Lump Sum C Payments',

Line 324: pay_balance_dimensions pbd

320: ) sort_index
321: , pdb.defined_balance_id defined_balance_id
322: FROM pay_balance_types pbt,
323: pay_defined_balances pdb,
324: pay_balance_dimensions pbd
325: WHERE pbt.legislation_code = 'AU'
326: AND pbt.balance_name in ( 'Lump Sum E Payments'
327: ,'Retro Earnings Leave Loading GT 12 Mths Amount'
328: ,'Retro Earnings Spread GT 12 Mths Amount'

Line 358: pay_balance_dimensions pbd

354: Cursor c_fbt_balance is
355: select pdb.defined_balance_id
356: from pay_balance_types pbt,
357: pay_defined_balances pdb,
358: pay_balance_dimensions pbd
359: where pbt.balance_name ='Fringe Benefits'
360: and pbt.balance_type_id = pdb.balance_type_id
361: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
362: and pbd.legislation_code ='AU'

Line 1030: pay_balance_dimensions pbd

1026: Cursor c_fbt_balance is
1027: select pdb.defined_balance_id
1028: from pay_balance_types pbt,
1029: pay_defined_balances pdb,
1030: pay_balance_dimensions pbd
1031: where pbt.balance_name ='Fringe Benefits'
1032: and pbt.balance_type_id = pdb.balance_type_id
1033: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
1034: and pbd.legislation_code ='AU'

Line 2567: ,pay_balance_dimensions pbd

2563: select 1
2564: from
2565: PAY_BALANCE_ATTRIBUTES pba
2566: ,pay_defined_balances pdb
2567: ,pay_balance_dimensions pbd
2568: ,PAY_BALANCE_FEEDS_F pbf
2569: where pba.attribute_id = g_attribute_id
2570: AND pba.defined_balance_id = pdb.defined_balance_id
2571: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2610: ,pay_balance_dimensions pbd

2606: ,pay_input_values_f piv
2607: ,pay_run_result_values prrv
2608: ,pay_balance_feeds_f pbf
2609: ,pay_defined_balances pdb
2610: ,pay_balance_dimensions pbd
2611: , pay_balance_attributes pba
2612: WHERE pba.attribute_id = g_attribute_id
2613: AND pdb.defined_balance_id = pba.defined_balance_id
2614: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2979: ,pay_balance_dimensions pbd

2975: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL) balance_value
2976: FROM pay_balance_attributes pba
2977: ,pay_defined_balances pdb
2978: ,pay_balance_types pbt
2979: ,pay_balance_dimensions pbd
2980: WHERE pba.attribute_id = g_attribute_id
2981: AND pdb.defined_balance_id = pba.defined_balance_id
2982: AND pbt.balance_type_id = pdb.balance_type_id
2983: AND pdb.balance_type_id = pbt.balance_type_id

Line 2999: ,pay_balance_dimensions pbd

2995: from pay_bal_attribute_definitions pbad
2996: ,pay_balance_attributes pba
2997: ,pay_defined_balances pdb
2998: ,pay_balance_types pbt
2999: ,pay_balance_dimensions pbd
3000: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'
3001: and pba.attribute_id = pbad.attribute_id
3002: and pba.defined_balance_id = pdb.defined_balance_id
3003: and pdb.balance_type_id = pbt.balance_type_id