eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_BALANCE_TYPES

Line 172: type r_allowance_bal is record (balance_name pay_balance_types.balance_name%type, balance_value number);

168:
169: -- Global variables for comparison
170: g_net_balance number ;
171: g_fw_union_value number;
172: type r_allowance_bal is record (balance_name pay_balance_types.balance_name%type, balance_value number);
173: type tab_allownace_balance is table of r_allowance_bal index by binary_integer;
174:
175: p_fw_union_tab_sorted tab_allownace_balance;
176: p_fw_alw_tab_sorted tab_allownace_balance;

Line 184: g_balance_type_id pay_balance_types.balance_type_id%type;

180: f_fw_date_tab_g pay_au_foreign_workers.tab_fw_dates;
181: j_fw_date_tab_g pay_au_foreign_workers.tab_fw_dates;
182:
183: p_fw_allowance_tab pay_au_payment_summary.t_allowance_balance%type;
184: g_balance_type_id pay_balance_types.balance_type_id%type;
185: p_fw_union_balance_type_tab pay_au_foreign_workers.tab_bal_type;
186: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
187:
188:

Line 292: FROM pay_balance_types pbt,

288: ,'Retro Earnings Additional GT 12 Mths Amount',40-- bug 13362286
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',

Line 322: FROM pay_balance_types pbt,

318: ,'Retro Pre Tax GT 12 Mths Amount', 4
319: ,'Retro Earnings Additional GT 12 Mths Amount', 5 -- bug 13362286
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'

Line 356: from pay_balance_types pbt,

352: where payroll_action_id = c_payroll_action_id;
353:
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

Line 380: from pay_balance_types

376: /* Changes for 9147438 starts*/
377:
378: cursor c_get_fw_fbt_bal_type_id is
379: select balance_type_id
380: from pay_balance_types
381: where balance_name = 'Fringe Benefits'
382: and legislation_code = 'AU';
383:
384: CURSOR c_get_fw_bal_type_id IS

Line 419: from pay_balance_types pbt

415: , 'Retro Earnings Additional LT12 Prev Mths Amount', 30
416: , 'Retro Earnings Additional LT12 Curr Mths Amount', 31
417: ) sort_index,
418: pbt.balance_type_id balance_type_id
419: from pay_balance_types pbt
420: where pbt.balance_name in (
421: 'Earnings_Total'
422: , 'Leave Payments Marginal'
423: , 'Workplace Giving Deductions'

Line 1028: from pay_balance_types pbt,

1024:
1025:
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

Line 1442: pay_balance_types pbt

1438:
1439: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
1440: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
1441: from pay_defined_balances pdb,
1442: pay_balance_types pbt
1443: where pdb.defined_balance_id = c_defined_balance_id
1444: and pdb.balance_type_id = pbt.balance_type_id
1445: and pdb.business_group_id = g_business_group_id;
1446:

Line 2549: pay_balance_types pbt

2545: and NOT EXISTS
2546: (
2547: select 1
2548: from pay_balance_feeds_f pbf,
2549: pay_balance_types pbt
2550: where pbt.balance_type_id = pbf.balance_type_id
2551: and pbt.balance_name in ('Invalidity Payments','Lump Sum A Payments',
2552: 'Lump Sum B Payments','Lump Sum C Payments',
2553: 'Lump Sum D Payments','Lump Sum E Payments',/*Bug 5846278 */

Line 2978: ,pay_balance_types pbt

2974: ,g_tax_unit_id
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

Line 2998: ,pay_balance_types pbt

2994: pbt.balance_name
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

Line 3012: pay_balance_types pbt

3008:
3009: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
3010: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
3011: from pay_defined_balances pdb,
3012: pay_balance_types pbt
3013: where pdb.defined_balance_id = c_defined_balance_id
3014: and pdb.balance_type_id = pbt.balance_type_id
3015: and pdb.business_group_id = g_business_group_id;
3016: