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_PAYTAX_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 305: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

301: ) IS
302:
303: /* 5139764 */
304: CURSOR csr_defined_balance_id
305: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
306: IS
307: SELECT decode(pbt.balance_name,'Payroll_Tax_Salaries_Wages',1,'Payroll_Tax_Commissions',2,
308: 'Payroll_Tax_Bonuses_Allowances',3,'Payroll_Tax_Director_Fees',4,
309: 'Payroll_Tax_Fringe_Benefits',7,'Payroll_Tax_Superannuation',8,

Line 314: pay_balance_dimensions pbd,

310: 'Payroll_Tax_Contractor_Payments',9, 'Payroll_Tax_Other_Taxable_Payments' , '10'
311: ) sort_index,
312: pdb.defined_balance_id defined_balance_id
313: FROM pay_balance_types pbt,
314: pay_balance_dimensions pbd,
315: pay_defined_balances pdb
316: WHERE pbt.balance_name IN ( 'Payroll_Tax_Salaries_Wages', 'Payroll_Tax_Commissions' ,
317: 'Payroll_Tax_Bonuses_Allowances', 'Payroll_Tax_Director_Fees',
318: 'Payroll_Tax_Fringe_Benefits', 'Payroll_Tax_Superannuation', 'Payroll_Tax_Contractor_Payments',

Line 331: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

327: l_ytd_dimension_name VARCHAR2(15);
328:
329: /* start 14134526 */
330: CURSOR csr_defined_balance_id_vic
331: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
332: IS
333: SELECT decode(pbt.balance_name,'Payroll_Tax_VIC_Salaries_Wages',1,'Payroll_Tax_VIC_Commissions',2,
334: 'Payroll_Tax_VIC_Bonuses_Allowances',3,'Payroll_Tax_VIC_Director_Fees',4,
335: 'Payroll_Tax_VIC_Fringe_Benefits',5,'Payroll_Tax_VIC_Superannuation',6,

Line 340: pay_balance_dimensions pbd,

336: 'Payroll_Tax_VIC_Contractor_Payments',7, 'Payroll_Tax_VIC_Other_Taxable_Payments',8
337: ) sort_index,
338: pdb.defined_balance_id defined_balance_id
339: FROM pay_balance_types pbt,
340: pay_balance_dimensions pbd,
341: pay_defined_balances pdb
342: WHERE pbt.balance_name IN ( 'Payroll_Tax_VIC_Salaries_Wages', 'Payroll_Tax_VIC_Commissions' ,
343: 'Payroll_Tax_VIC_Bonuses_Allowances', 'Payroll_Tax_VIC_Director_Fees',
344: 'Payroll_Tax_VIC_Fringe_Benefits', 'Payroll_Tax_VIC_Superannuation',

Line 353: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

349: AND pbt.legislation_code = 'AU'
350: ORDER BY sort_index;
351:
352: CURSOR csr_defined_balance_id_nsw
353: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
354: IS
355: SELECT decode(pbt.balance_name,'Payroll_Tax_NSW_Salaries_Wages',1,'Payroll_Tax_NSW_Commissions',2,
356: 'Payroll_Tax_NSW_Bonuses_Allowances',3,'Payroll_Tax_NSW_Director_Fees',4,
357: 'Payroll_Tax_NSW_Fringe_Benefits',5,'Payroll_Tax_NSW_Superannuation',6,

Line 362: pay_balance_dimensions pbd,

358: 'Payroll_Tax_NSW_Contractor_Payments',7, 'Payroll_Tax_NSW_Other_Taxable_Payments',8
359: ) sort_index,
360: pdb.defined_balance_id defined_balance_id
361: FROM pay_balance_types pbt,
362: pay_balance_dimensions pbd,
363: pay_defined_balances pdb
364: WHERE pbt.balance_name IN ( 'Payroll_Tax_NSW_Salaries_Wages', 'Payroll_Tax_NSW_Commissions' ,
365: 'Payroll_Tax_NSW_Bonuses_Allowances', 'Payroll_Tax_NSW_Director_Fees',
366: 'Payroll_Tax_NSW_Fringe_Benefits', 'Payroll_Tax_NSW_Superannuation',

Line 375: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

371: AND pbt.legislation_code = 'AU'
372: ORDER BY sort_index;
373:
374: CURSOR csr_defined_balance_id_act
375: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
376: IS
377: SELECT decode(pbt.balance_name,'Payroll_Tax_ACT_Salaries_Wages',1,'Payroll_Tax_ACT_Commissions',2,
378: 'Payroll_Tax_ACT_Bonuses_Allowances',3,'Payroll_Tax_ACT_Director_Fees',4,
379: 'Payroll_Tax_ACT_Fringe_Benefits',5,'Payroll_Tax_ACT_Superannuation',6,

Line 384: pay_balance_dimensions pbd,

380: 'Payroll_Tax_ACT_Contractor_Payments',7, 'Payroll_Tax_ACT_Other_Taxable_Payments',8
381: ) sort_index,
382: pdb.defined_balance_id defined_balance_id
383: FROM pay_balance_types pbt,
384: pay_balance_dimensions pbd,
385: pay_defined_balances pdb
386: WHERE pbt.balance_name IN ( 'Payroll_Tax_ACT_Salaries_Wages', 'Payroll_Tax_ACT_Commissions' ,
387: 'Payroll_Tax_ACT_Bonuses_Allowances', 'Payroll_Tax_ACT_Director_Fees',
388: 'Payroll_Tax_ACT_Fringe_Benefits', 'Payroll_Tax_ACT_Superannuation',

Line 397: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

393: AND pbt.legislation_code = 'AU'
394: ORDER BY sort_index;
395:
396: CURSOR csr_defined_balance_id_sa
397: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
398: IS
399: SELECT decode(pbt.balance_name,'Payroll_Tax_SA_Salaries_Wages',1,'Payroll_Tax_SA_Commissions',2,
400: 'Payroll_Tax_SA_Bonuses_Allowances',3,'Payroll_Tax_SA_Director_Fees',4,
401: 'Payroll_Tax_SA_Fringe_Benefits',5,'Payroll_Tax_SA_Superannuation',6,

Line 406: pay_balance_dimensions pbd,

402: 'Payroll_Tax_SA_Contractor_Payments',7, 'Payroll_Tax_SA_Other_Taxable_Payments',8
403: ) sort_index,
404: pdb.defined_balance_id defined_balance_id
405: FROM pay_balance_types pbt,
406: pay_balance_dimensions pbd,
407: pay_defined_balances pdb
408: WHERE pbt.balance_name IN ( 'Payroll_Tax_SA_Salaries_Wages', 'Payroll_Tax_SA_Commissions' ,
409: 'Payroll_Tax_SA_Bonuses_Allowances', 'Payroll_Tax_SA_Director_Fees',
410: 'Payroll_Tax_SA_Fringe_Benefits', 'Payroll_Tax_SA_Superannuation',

Line 419: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

415: AND pbt.legislation_code = 'AU'
416: ORDER BY sort_index;
417:
418: CURSOR csr_defined_balance_id_qld
419: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
420: IS
421: SELECT decode(pbt.balance_name,'Payroll_Tax_QLD_Salaries_Wages',1,'Payroll_Tax_QLD_Commissions',2,
422: 'Payroll_Tax_QLD_Bonuses_Allowances',3,'Payroll_Tax_QLD_Director_Fees',4,
423: 'Payroll_Tax_QLD_Fringe_Benefits',5,'Payroll_Tax_QLD_Superannuation',6,

Line 428: pay_balance_dimensions pbd,

424: 'Payroll_Tax_QLD_Contractor_Payments',7, 'Payroll_Tax_QLD_Other_Taxable_Payments',8
425: ) sort_index,
426: pdb.defined_balance_id defined_balance_id
427: FROM pay_balance_types pbt,
428: pay_balance_dimensions pbd,
429: pay_defined_balances pdb
430: WHERE pbt.balance_name IN ( 'Payroll_Tax_QLD_Salaries_Wages', 'Payroll_Tax_QLD_Commissions' ,
431: 'Payroll_Tax_QLD_Bonuses_Allowances', 'Payroll_Tax_QLD_Director_Fees',
432: 'Payroll_Tax_QLD_Fringe_Benefits', 'Payroll_Tax_QLD_Superannuation',

Line 441: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

437: AND pbt.legislation_code = 'AU'
438: ORDER BY sort_index;
439:
440: CURSOR csr_defined_balance_id_tas
441: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
442: IS
443: SELECT decode(pbt.balance_name,'Payroll_Tax_TAS_Salaries_Wages',1,'Payroll_Tax_TAS_Commissions',2,
444: 'Payroll_Tax_TAS_Bonuses_Allowances',3,'Payroll_Tax_TAS_Director_Fees',4,
445: 'Payroll_Tax_TAS_Fringe_Benefits',5,'Payroll_Tax_TAS_Superannuation',6,

Line 450: pay_balance_dimensions pbd,

446: 'Payroll_Tax_TAS_Contractor_Payments',7, 'Payroll_Tax_TAS_Other_Taxable_Payments',8
447: ) sort_index,
448: pdb.defined_balance_id defined_balance_id
449: FROM pay_balance_types pbt,
450: pay_balance_dimensions pbd,
451: pay_defined_balances pdb
452: WHERE pbt.balance_name IN ( 'Payroll_Tax_TAS_Salaries_Wages', 'Payroll_Tax_TAS_Commissions' ,
453: 'Payroll_Tax_TAS_Bonuses_Allowances', 'Payroll_Tax_TAS_Director_Fees',
454: 'Payroll_Tax_TAS_Fringe_Benefits', 'Payroll_Tax_TAS_Superannuation',

Line 463: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

459: AND pbt.legislation_code = 'AU'
460: ORDER BY sort_index;
461:
462: CURSOR csr_defined_balance_id_wa
463: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
464: IS
465: SELECT decode(pbt.balance_name,'Payroll_Tax_WA_Salaries_Wages',1,'Payroll_Tax_WA_Commissions',2,
466: 'Payroll_Tax_WA_Bonuses_Allowances',3,'Payroll_Tax_WA_Director_Fees',4,
467: 'Payroll_Tax_WA_Fringe_Benefits',5,'Payroll_Tax_WA_Superannuation',6,

Line 472: pay_balance_dimensions pbd,

468: 'Payroll_Tax_WA_Contractor_Payments',7, 'Payroll_Tax_WA_Other_Taxable_Payments',8
469: ) sort_index,
470: pdb.defined_balance_id defined_balance_id
471: FROM pay_balance_types pbt,
472: pay_balance_dimensions pbd,
473: pay_defined_balances pdb
474: WHERE pbt.balance_name IN ( 'Payroll_Tax_WA_Salaries_Wages', 'Payroll_Tax_WA_Commissions' ,
475: 'Payroll_Tax_WA_Bonuses_Allowances', 'Payroll_Tax_WA_Director_Fees',
476: 'Payroll_Tax_WA_Fringe_Benefits', 'Payroll_Tax_WA_Superannuation',

Line 485: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

481: AND pbt.legislation_code = 'AU'
482: ORDER BY sort_index;
483:
484: CURSOR csr_defined_balance_id_nt
485: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
486: IS
487: SELECT decode(pbt.balance_name,'Payroll_Tax_NT_Salaries_Wages',1,'Payroll_Tax_NT_Commissions',2,
488: 'Payroll_Tax_NT_Bonuses_Allowances',3,'Payroll_Tax_NT_Director_Fees',4,
489: 'Payroll_Tax_NT_Fringe_Benefits',5,'Payroll_Tax_NT_Superannuation',6,

Line 494: pay_balance_dimensions pbd,

490: 'Payroll_Tax_NT_Contractor_Payments',7, 'Payroll_Tax_NT_Other_Taxable_Payments',8
491: ) sort_index,
492: pdb.defined_balance_id defined_balance_id
493: FROM pay_balance_types pbt,
494: pay_balance_dimensions pbd,
495: pay_defined_balances pdb
496: WHERE pbt.balance_name IN ( 'Payroll_Tax_NT_Salaries_Wages', 'Payroll_Tax_NT_Commissions' ,
497: 'Payroll_Tax_NT_Bonuses_Allowances', 'Payroll_Tax_NT_Director_Fees',
498: 'Payroll_Tax_NT_Fringe_Benefits', 'Payroll_Tax_NT_Superannuation',

Line 660: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

656:
657:
658: /* 4713372 */
659: CURSOR csr_Paytax_defined_balance_id
660: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
661: c_state_code varchar2)
662: IS
663: SELECT pdb.defined_balance_id defined_balance_id
664: FROM pay_balance_types pbt,

Line 665: pay_balance_dimensions pbd,

661: c_state_code varchar2)
662: IS
663: SELECT pdb.defined_balance_id defined_balance_id
664: FROM pay_balance_types pbt,
665: pay_balance_dimensions pbd,
666: pay_defined_balances pdb
667: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code
668: AND pbd.database_item_suffix = c_database_item_suffix
669: AND pbt.balance_type_id = pdb.balance_type_id

Line 675: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

671: AND pbt.legislation_code = 'AU';
672:
673: /* 5139764 */
674: CURSOR csr_TPaytax_defined_balance_id
675: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
676: c_state_code varchar2)
677: IS
678: SELECT pdb.defined_balance_id defined_balance_id
679: FROM pay_balance_types pbt,

Line 680: pay_balance_dimensions pbd,

676: c_state_code varchar2)
677: IS
678: SELECT pdb.defined_balance_id defined_balance_id
679: FROM pay_balance_types pbt,
680: pay_balance_dimensions pbd,
681: pay_defined_balances pdb
682: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code || '_Termination_Payments'
683: AND pbd.database_item_suffix = c_database_item_suffix
684: AND pbt.balance_type_id = pdb.balance_type_id

Line 692: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

688:
689: /* 5139764 */
690:
691: CURSOR csr_ETPaytax_defined_balance
692: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
693: c_state_code varchar2)
694: IS
695: SELECT pdb.defined_balance_id defined_balance_id
696: FROM pay_balance_types pbt,

Line 697: pay_balance_dimensions pbd,

693: c_state_code varchar2)
694: IS
695: SELECT pdb.defined_balance_id defined_balance_id
696: FROM pay_balance_types pbt,
697: pay_balance_dimensions pbd,
698: pay_defined_balances pdb
699: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code || '_Eligible_Termination_Payments'
700: AND pbd.database_item_suffix = c_database_item_suffix
701: AND pbt.balance_type_id = pdb.balance_type_id

Line 1176: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

1172: and pai.action_context_id = c_arc_ass_act_id;
1173:
1174:
1175: CURSOR csr_Paytax_defined_balance_id
1176: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
1177: c_state_code varchar2)
1178: IS
1179: SELECT pdb.defined_balance_id defined_balance_id
1180: FROM pay_balance_types pbt,

Line 1181: pay_balance_dimensions pbd,

1177: c_state_code varchar2)
1178: IS
1179: SELECT pdb.defined_balance_id defined_balance_id
1180: FROM pay_balance_types pbt,
1181: pay_balance_dimensions pbd,
1182: pay_defined_balances pdb
1183: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code
1184: AND pbd.database_item_suffix = c_database_item_suffix
1185: AND pbt.balance_type_id = pdb.balance_type_id

Line 1193: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

1189:
1190: /* 5139764 */
1191:
1192: CURSOR csr_TPaytax_defined_balance_id
1193: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
1194: c_state_code varchar2)
1195: IS
1196: SELECT pdb.defined_balance_id defined_balance_id
1197: FROM pay_balance_types pbt,

Line 1198: pay_balance_dimensions pbd,

1194: c_state_code varchar2)
1195: IS
1196: SELECT pdb.defined_balance_id defined_balance_id
1197: FROM pay_balance_types pbt,
1198: pay_balance_dimensions pbd,
1199: pay_defined_balances pdb
1200: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code || '_Termination_Payments'
1201: AND pbd.database_item_suffix = c_database_item_suffix
1202: AND pbt.balance_type_id = pdb.balance_type_id

Line 1210: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

1206:
1207: /* 5139764 */
1208:
1209: CURSOR csr_ETPaytax_defined_balance
1210: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
1211: c_state_code varchar2)
1212: IS
1213: SELECT pdb.defined_balance_id defined_balance_id
1214: FROM pay_balance_types pbt,

Line 1215: pay_balance_dimensions pbd,

1211: c_state_code varchar2)
1212: IS
1213: SELECT pdb.defined_balance_id defined_balance_id
1214: FROM pay_balance_types pbt,
1215: pay_balance_dimensions pbd,
1216: pay_defined_balances pdb
1217: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code || '_Eligible_Termination_Payments'
1218: AND pbd.database_item_suffix = c_database_item_suffix
1219: AND pbt.balance_type_id = pdb.balance_type_id