DBA Data[Home] [Help]

APPS.PAY_AU_PAYTAX_PKG dependencies on PAY_DEFINED_BALANCES

Line 315: pay_defined_balances pdb

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',
319: 'Payroll_Tax_Other_Taxable_Payments' )

Line 341: pay_defined_balances pdb

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',
345: 'Payroll_Tax_VIC_Contractor_Payments','Payroll_Tax_VIC_Other_Taxable_Payments')

Line 363: pay_defined_balances pdb

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',
367: 'Payroll_Tax_NSW_Contractor_Payments','Payroll_Tax_NSW_Other_Taxable_Payments')

Line 385: pay_defined_balances pdb

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',
389: 'Payroll_Tax_ACT_Contractor_Payments','Payroll_Tax_ACT_Other_Taxable_Payments')

Line 407: pay_defined_balances pdb

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',
411: 'Payroll_Tax_SA_Contractor_Payments','Payroll_Tax_SA_Other_Taxable_Payments')

Line 429: pay_defined_balances pdb

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',
433: 'Payroll_Tax_QLD_Contractor_Payments','Payroll_Tax_QLD_Other_Taxable_Payments')

Line 451: pay_defined_balances pdb

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',
455: 'Payroll_Tax_TAS_Contractor_Payments','Payroll_Tax_TAS_Other_Taxable_Payments')

Line 473: pay_defined_balances pdb

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',
477: 'Payroll_Tax_WA_Contractor_Payments','Payroll_Tax_WA_Other_Taxable_Payments')

Line 495: pay_defined_balances pdb

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',
499: 'Payroll_Tax_NT_Contractor_Payments','Payroll_Tax_NT_Other_Taxable_Payments')

Line 666: pay_defined_balances pdb

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
670: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 681: pay_defined_balances pdb

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
685: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 698: pay_defined_balances pdb

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
702: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1182: pay_defined_balances pdb

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
1186: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1199: pay_defined_balances pdb

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
1203: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1216: pay_defined_balances pdb

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
1220: AND pbd.balance_dimension_id = pdb.balance_dimension_id