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_DEFINED_BALANCES

Line 231: PAY_DEFINED_BALANCES PDB ,

227: PDB.BALANCE_TYPE_ID
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 ,

Line 278: c_balance_type_id pay_defined_balances.defined_balance_id%type)

274: ;
275:
276:
277: Cursor Get_Retro_allowances(c_element_entry_id pay_element_entries_f.element_entry_id%type,
278: c_balance_type_id pay_defined_balances.defined_balance_id%type)
279: IS
280: select NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
281: ,prv.result_value balance_value
282: from

Line 489: CURSOR get_alw_balance_name (p_def_bal_id pay_defined_balances.defined_balance_id%type) IS

485: p_assignment_action_id pay_assignment_actions.assignment_id%type,
486: p_tax_unit_id hr_all_organization_units.organization_id%type)
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

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 1019: pay_defined_balances pdb,

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

Line 1178: pay_defined_balances pdb, --Bug# 3193479

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

Line 1286: ,pay_defined_balances pdb

1282: select pbt.balance_type_id,
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

Line 1312: ,pay_defined_balances pdb

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

Line 1326: l_alw_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

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 */
1330:

Line 1338: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE; --Bug# 3193479

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 ;
1342:

Line 1346: pay_defined_balances pdb,

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

Line 1729: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)

1725: return g_etp_tax;
1726: end etp_tax;
1727:
1728: --------------------Bug# 3193479-----------------------------------------------------------------
1729: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
1730: return number is
1731: begin
1732: for i in 1..g_result_table.last
1733: loop

Line 1760: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is

1756: l_net_balance NUMBER := 0; -- 3098353
1757:
1758: /* Changes for 9147438 start */
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

Line 1762: from pay_defined_balances pdb,

1758: /* Changes for 9147438 start */
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;

Line 2398: , pay_defined_balances pdb

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
2402: ('Lump Sum A Payments','Lump Sum B Payments','Lump Sum D Payments',

Line 2414: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

2410: AND pbd.dimension_name = p_dimension_name
2411: ORDER BY sort_index;
2412:
2413: l_sort_index number;
2414: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
2415:
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

Line 2421: ,pay_defined_balances pdb

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

Line 2432: ,pay_defined_balances pdb2

2428: AND exists (
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

Line 3212: pay_defined_balances pdb,

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