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_DIMENSIONS

Line 232: PAY_BALANCE_DIMENSIONS PBD ,

228: FROM
229: PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD ,
230: PAY_BALANCE_ATTRIBUTES PBA ,
231: PAY_DEFINED_BALANCES PDB ,
232: PAY_BALANCE_DIMENSIONS PBD ,
233: PAY_BALANCE_FEEDS_F PBF ,
234: PAY_INPUT_VALUES_F PIV,
235: PAY_ELEMENT_ENTRIES_F PEE ,
236: PAY_ELEMENT_TYPES_F PET ,

Line 1020: pay_balance_dimensions pbd

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'
1023: ,'Retro Earnings Leave Loading GT 12 Mths Amount'
1024: ,'Retro Earnings Spread GT 12 Mths Amount'

Line 1175: CURSOR c_bal_id (c_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS

1171: /* Bug 8587013 - Added two balances 'Reportable Employer Superannuation Contributions' and 'Exempt Foreign Employment Income'
1172: and removed 'Other Income' balance */
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

Line 1179: pay_balance_dimensions pbd

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
1182: ('CDEP','Earnings_Total','Lump Sum A Deductions',
1183: 'Lump Sum A Payments','Lump Sum B Deductions','Lump Sum B Payments',

Line 1209: CURSOR c_fw_bal_id (c_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS

1205: AND pdb.legislation_code = 'AU'
1206: AND pbd.dimension_name = c_dimension_name;
1207:
1208: /* Changes for 9147438 starts*/
1209: CURSOR c_fw_bal_id (c_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS
1210: SELECT decode(pbt.balance_name,'Earnings_Total',1
1211: , 'Leave Payments Marginal',2
1212: , 'Workplace Giving Deductions',3
1213: , 'Lump Sum E Payments',4

Line 1288: ,pay_balance_dimensions pbd

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
1292: and pdb.balance_type_id = pbt.balance_type_id

Line 1314: ,pay_balance_dimensions pbd

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
1318: and pdb.balance_type_id = pbt.balance_type_id

Line 1339: c_dimension_name pay_balance_dimensions.dimension_name%TYPE; -- Bug: 3186840

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 ;
1342:
1343: Cursor c_fbt_balance IS --Bug#3749530

Line 1347: pay_balance_dimensions pbd

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
1350: and pdb.balance_dimension_id = pbd.balance_dimension_id
1351: and pbd.legislation_code ='AU'

Line 2386: PROCEDURE populate_group_def_bal_ids(p_dimension_name pay_balance_dimensions.dimension_name%TYPE

2382:
2383: /* Start of Bug : 3186840 */
2384: /* Bug 8587013 - Added balances 'Reportable Employer Superannuation Contributions' and 'Exempt Foreign Employment Income'
2385: and removed Other Income balance */
2386: PROCEDURE populate_group_def_bal_ids(p_dimension_name pay_balance_dimensions.dimension_name%TYPE
2387: ,p_business_group_id per_business_groups.business_group_id%TYPE)
2388: IS
2389:
2390: CURSOR csr_group_def_bal_ids IS

Line 2399: , pay_balance_dimensions pbd

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
2402: ('Lump Sum A Payments','Lump Sum B Payments','Lump Sum D Payments',
2403: 'Union Fees','Lump Sum C Deductions','Termination Deductions',

Line 2422: ,pay_balance_dimensions pbd

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
2425: AND pbd.dimension_name = p_dimension_name
2426: AND pdb.business_group_id = p_business_group_id

Line 2433: ,pay_balance_dimensions pbd2

2429: select null
2430: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
2431: ,pay_balance_attributes pba
2432: ,pay_defined_balances pdb2
2433: ,pay_balance_dimensions pbd2
2434: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'
2435: and pba.attribute_id = pbad.attribute_id
2436: and pba.defined_balance_id = pdb2.defined_balance_id
2437: and pdb2.business_group_id = p_business_group_id

Line 3213: pay_balance_dimensions pbd

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
3216: and pdb.balance_dimension_id = pbd.balance_dimension_id
3217: and pbd.legislation_code ='AU'