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 227: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

223: ) IS
224:
225: /* 5139764 */
226: CURSOR csr_defined_balance_id
227: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
228: IS
229: SELECT decode(pbt.balance_name,'Payroll_Tax_Salaries_Wages',1,'Payroll_Tax_Commissions',2,
230: 'Payroll_Tax_Bonuses_Allowances',3,'Payroll_Tax_Director_Fees',4,
231: 'Payroll_Tax_Fringe_Benefits',7,'Payroll_Tax_Superannuation',8,

Line 236: pay_balance_dimensions pbd,

232: 'Payroll_Tax_Contractor_Payments',9, 'Payroll_Tax_Other_Taxable_Payments' , '10'
233: ) sort_index,
234: pdb.defined_balance_id defined_balance_id
235: FROM pay_balance_types pbt,
236: pay_balance_dimensions pbd,
237: pay_defined_balances pdb
238: WHERE pbt.balance_name IN ( 'Payroll_Tax_Salaries_Wages', 'Payroll_Tax_Commissions' ,
239: 'Payroll_Tax_Bonuses_Allowances', 'Payroll_Tax_Director_Fees',
240: 'Payroll_Tax_Fringe_Benefits', 'Payroll_Tax_Superannuation', 'Payroll_Tax_Contractor_Payments',

Line 362: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

358:
359:
360: /* 4713372 */
361: CURSOR csr_Paytax_defined_balance_id
362: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
363: c_state_code varchar2)
364: IS
365: SELECT pdb.defined_balance_id defined_balance_id
366: FROM pay_balance_types pbt,

Line 367: pay_balance_dimensions pbd,

363: c_state_code varchar2)
364: IS
365: SELECT pdb.defined_balance_id defined_balance_id
366: FROM pay_balance_types pbt,
367: pay_balance_dimensions pbd,
368: pay_defined_balances pdb
369: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code
370: AND pbd.database_item_suffix = c_database_item_suffix
371: AND pbt.balance_type_id = pdb.balance_type_id

Line 377: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

373: AND pbt.legislation_code = 'AU';
374:
375: /* 5139764 */
376: CURSOR csr_TPaytax_defined_balance_id
377: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
378: c_state_code varchar2)
379: IS
380: SELECT pdb.defined_balance_id defined_balance_id
381: FROM pay_balance_types pbt,

Line 382: pay_balance_dimensions pbd,

378: c_state_code varchar2)
379: IS
380: SELECT pdb.defined_balance_id defined_balance_id
381: FROM pay_balance_types pbt,
382: pay_balance_dimensions pbd,
383: pay_defined_balances pdb
384: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code || '_Termination_Payments'
385: AND pbd.database_item_suffix = c_database_item_suffix
386: AND pbt.balance_type_id = pdb.balance_type_id

Line 394: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

390:
391: /* 5139764 */
392:
393: CURSOR csr_ETPaytax_defined_balance
394: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
395: c_state_code varchar2)
396: IS
397: SELECT pdb.defined_balance_id defined_balance_id
398: FROM pay_balance_types pbt,

Line 399: pay_balance_dimensions pbd,

395: c_state_code varchar2)
396: IS
397: SELECT pdb.defined_balance_id defined_balance_id
398: FROM pay_balance_types pbt,
399: pay_balance_dimensions pbd,
400: pay_defined_balances pdb
401: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code || '_Eligible_Termination_Payments'
402: AND pbd.database_item_suffix = c_database_item_suffix
403: AND pbt.balance_type_id = pdb.balance_type_id

Line 875: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

871: and pai.action_context_id = c_arc_ass_act_id;
872:
873:
874: CURSOR csr_Paytax_defined_balance_id
875: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
876: c_state_code varchar2)
877: IS
878: SELECT pdb.defined_balance_id defined_balance_id
879: FROM pay_balance_types pbt,

Line 880: pay_balance_dimensions pbd,

876: c_state_code varchar2)
877: IS
878: SELECT pdb.defined_balance_id defined_balance_id
879: FROM pay_balance_types pbt,
880: pay_balance_dimensions pbd,
881: pay_defined_balances pdb
882: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code
883: AND pbd.database_item_suffix = c_database_item_suffix
884: AND pbt.balance_type_id = pdb.balance_type_id

Line 892: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

888:
889: /* 5139764 */
890:
891: CURSOR csr_TPaytax_defined_balance_id
892: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
893: c_state_code varchar2)
894: IS
895: SELECT pdb.defined_balance_id defined_balance_id
896: FROM pay_balance_types pbt,

Line 897: pay_balance_dimensions pbd,

893: c_state_code varchar2)
894: IS
895: SELECT pdb.defined_balance_id defined_balance_id
896: FROM pay_balance_types pbt,
897: pay_balance_dimensions pbd,
898: pay_defined_balances pdb
899: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code || '_Termination_Payments'
900: AND pbd.database_item_suffix = c_database_item_suffix
901: AND pbt.balance_type_id = pdb.balance_type_id

Line 909: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,

905:
906: /* 5139764 */
907:
908: CURSOR csr_ETPaytax_defined_balance
909: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type,
910: c_state_code varchar2)
911: IS
912: SELECT pdb.defined_balance_id defined_balance_id
913: FROM pay_balance_types pbt,

Line 914: pay_balance_dimensions pbd,

910: c_state_code varchar2)
911: IS
912: SELECT pdb.defined_balance_id defined_balance_id
913: FROM pay_balance_types pbt,
914: pay_balance_dimensions pbd,
915: pay_defined_balances pdb
916: WHERE pbt.balance_name = 'Payroll_Tax_' || c_state_code || '_Eligible_Termination_Payments'
917: AND pbd.database_item_suffix = c_database_item_suffix
918: AND pbt.balance_type_id = pdb.balance_type_id