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_RECON_SUMMARY dependencies on PAY_BALANCE_TYPES

Line 171: g_balance_type_id pay_balance_types.balance_type_id%type;

167: g_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
168: g_fw_total_resc number;
169: g_fw_total_cdep number;
170: g_fw_total_workplace number;
171: g_balance_type_id pay_balance_types.balance_type_id%type;
172: p_fw_fbt_bal_type_tab pay_au_foreign_workers.tab_bal_type;
173: g_fw_fbt_balance number;
174: g_fw_reporting_amt number;
175: /* Changes for 9147438 end */

Line 287: pay_balance_types pbt

283: pay_element_entries_f pee,
284: pay_run_results prr,
285: pay_run_result_values prv,
286: pay_element_types_f pet,
287: pay_balance_types pbt
288: ,PAY_BALANCE_FEEDS_F pbf
289: ,pay_input_values_f piv
290: where
291: pee.element_entry_id=c_element_entry_id

Line 312: TYPE r_ret_allowances IS RECORD(balance_name pay_balance_types.balance_name%TYPE,

308: WHERE plr.legislation_code = 'AU'
309: AND plr.rule_type ='ADVANCED_RETRO';
310:
311: rec_retro_Allowances Get_retro_Allowances%ROWTYPE;
312: TYPE r_ret_allowances IS RECORD(balance_name pay_balance_types.balance_name%TYPE,
313: balance_value Number);
314: TYPE tab_ret_allowances IS TABLE OF r_ret_allowances INDEX BY BINARY_INTEGER;
315: t_ret_allowances tab_ret_allowances;
316:

Line 491: from pay_balance_types pbt, pay_defined_balances pdb

487: return number is
488:
489: CURSOR get_alw_balance_name (p_def_bal_id pay_defined_balances.defined_balance_id%type) IS
490: select NVL(pbt.reporting_name,pbt.balance_name)
491: from pay_balance_types pbt, pay_defined_balances pdb
492: where pdb.defined_balance_id = p_def_bal_id
493: and pdb.balance_type_id = pbt.balance_type_id
494: ;
495:

Line 497: l_balance_name pay_balance_types.balance_name%type;

493: and pdb.balance_type_id = pbt.balance_type_id
494: ;
495:
496: t_allowance_balance pay_au_payment_summary.t_allowance_balance%type;
497: l_balance_name pay_balance_types.balance_name%type;
498: cnt number := 1;
499: counter number := 1;
500: i number;
501:

Line 1018: FROM pay_balance_types pbt,

1014: ,'Retro Earnings Spread GT 12 Mths Amount', 3
1015: ,'Retro Pre Tax GT 12 Mths Amount', 4
1016: ,'Retro Earnings Additional GT 12 Mths Amount', 5) sort_index
1017: , pdb.defined_balance_id defined_balance_id
1018: FROM pay_balance_types pbt,
1019: pay_defined_balances pdb,
1020: pay_balance_dimensions pbd
1021: WHERE pbt.legislation_code = 'AU'
1022: AND pbt.balance_name in ( 'Lump Sum E Payments'

Line 1177: FROM pay_balance_types pbt,

1173: /* Bug 8769345 - Added ETP Taxable and Tax Free balances to the cursor */
1174: /* Bug 10331262 - Added Foreign Leave and Termination Payment balances */
1175: CURSOR c_bal_id (c_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS
1176: SELECT pbt.balance_name,pbt.balance_type_id,pdb.defined_balance_id
1177: FROM pay_balance_types pbt,
1178: pay_defined_balances pdb, --Bug# 3193479
1179: pay_balance_dimensions pbd
1180: where pbt.legislation_code = 'AU'
1181: and pbt.balance_name in

Line 1243: FROM pay_balance_types pbt

1239: , 'Retro Earnings Additional LT12 Prev Mths Amount', 30
1240: , 'Retro Earnings Additional LT12 Curr Mths Amount', 31
1241: ) sort_index,
1242: pbt.balance_type_id balance_type_id
1243: FROM pay_balance_types pbt
1244: WHERE pbt.legislation_code = 'AU'
1245: and pbt.balance_name in ('Earnings_Total'
1246: , 'Leave Payments Marginal'
1247: , 'Workplace Giving Deductions'

Line 1287: ,pay_balance_types pbt

1283: pbt.balance_name
1284: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
1285: ,pay_balance_attributes pba
1286: ,pay_defined_balances pdb
1287: ,pay_balance_types pbt
1288: ,pay_balance_dimensions pbd
1289: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'
1290: and pba.attribute_id = pbad.attribute_id
1291: and pba.defined_balance_id = pdb.defined_balance_id

Line 1300: from pay_balance_types

1296: and pbd.legislation_code = 'AU';
1297:
1298: cursor c_get_fw_fbt_bal_type_id is
1299: select balance_type_id
1300: from pay_balance_types
1301: where balance_name = 'Fringe Benefits'
1302: and legislation_code = 'AU';
1303:
1304: /* Changes for 9147438 end */

Line 1313: ,pay_balance_types pbt

1309: , pdb.defined_balance_id
1310: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
1311: ,pay_balance_attributes pba
1312: ,pay_defined_balances pdb
1313: ,pay_balance_types pbt
1314: ,pay_balance_dimensions pbd
1315: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'
1316: and pba.attribute_id = pbad.attribute_id
1317: and pba.defined_balance_id = pdb.defined_balance_id

Line 1325: l_alw_bal_name pay_balance_types.balance_name%type;

1321: and pbd.dimension_name = '_ASG_LE_YTD'
1322: and pbd.legislation_code = 'AU'
1323: ;
1324:
1325: l_alw_bal_name pay_balance_types.balance_name%type;
1326: l_alw_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
1327: cnt number := 1;
1328: idx number := 1;
1329: /* end bug 7571001 - new cursor c_alw_bal_id is added */

Line 1336: l_bal_name pay_balance_types.balance_name%type;

1332:
1333:
1334: i number;
1335: j number;
1336: l_bal_name pay_balance_types.balance_name%type;
1337: l_bal_id pay_balance_types.balance_type_id%type;
1338: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE; --Bug# 3193479
1339: c_dimension_name pay_balance_dimensions.dimension_name%TYPE; -- Bug: 3186840
1340: g_debug boolean;

Line 1337: l_bal_id pay_balance_types.balance_type_id%type;

1333:
1334: i number;
1335: j number;
1336: l_bal_name pay_balance_types.balance_name%type;
1337: l_bal_id pay_balance_types.balance_type_id%type;
1338: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE; --Bug# 3193479
1339: c_dimension_name pay_balance_dimensions.dimension_name%TYPE; -- Bug: 3186840
1340: g_debug boolean;
1341: l_sort_index number ;

Line 1345: from pay_balance_types pbt,

1341: l_sort_index number ;
1342:
1343: Cursor c_fbt_balance IS --Bug#3749530
1344: select pdb.defined_balance_id
1345: from pay_balance_types pbt,
1346: pay_defined_balances pdb,
1347: pay_balance_dimensions pbd
1348: where pbt.balance_name ='Fringe Benefits'
1349: and pbt.balance_type_id = pdb.balance_type_id

Line 1763: pay_balance_types pbt

1759:
1760: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
1761: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
1762: from pay_defined_balances pdb,
1763: pay_balance_types pbt
1764: where pdb.defined_balance_id = c_defined_balance_id
1765: and pdb.balance_type_id = pbt.balance_type_id
1766: and pdb.business_group_id = g_business_group_id;
1767:

Line 2397: FROM pay_balance_types pbt

2393: 'Termination Deductions',6,'Total_Tax_Deductions',7,'Earnings_Total',8,'Leave Payments Marginal',9,
2394: 'CDEP',10,'Reportable Employer Superannuation Contributions', 11 ,'Workplace Giving Deductions', 12 ,
2395: 'Exempt Foreign Employment Income' ,13) sort_index /*4015082 , 8587013*/
2396: , pdb.defined_balance_id
2397: FROM pay_balance_types pbt
2398: , pay_defined_balances pdb
2399: , pay_balance_dimensions pbd
2400: WHERE pbt.legislation_code = 'AU'
2401: AND pbt.balance_name in

Line 2420: from pay_balance_types pbt

2416: /* bug 7571001 - added csr_group_alw_def_bal_ids cursor for allowance balances */
2417: CURSOR csr_group_alw_def_bal_ids IS
2418: select pbt.balance_name
2419: ,pdb.defined_balance_id
2420: from pay_balance_types pbt
2421: ,pay_defined_balances pdb
2422: ,pay_balance_dimensions pbd
2423: where pdb.balance_type_id = pbt.balance_type_id
2424: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 2477: FROM pay_balance_types pbt

2473: , 'Foreign Leave Payments', 28
2474: , 'Retro Earnings Additional GT 12 Mths Amount', 29 -- bug 13362286
2475: ) sort_index,
2476: pbt.balance_type_id balance_type_id
2477: FROM pay_balance_types pbt
2478: WHERE pbt.legislation_code = 'AU'
2479: and pbt.balance_name in (
2480: 'Earnings_Total'
2481: , 'Leave Payments Marginal'

Line 3211: from pay_balance_types pbt,

3207:
3208:
3209: Cursor c_fbt_balance is
3210: select pdb.defined_balance_id
3211: from pay_balance_types pbt,
3212: pay_defined_balances pdb,
3213: pay_balance_dimensions pbd
3214: where pbt.balance_name ='Fringe Benefits'
3215: and pbt.balance_type_id = pdb.balance_type_id