APPS.PAY_AU_PAYTAX_PKG dependencies on PAY_BALANCE_TYPES

Line 235: FROM pay_balance_types pbt,

231: 'Payroll_Tax_Fringe_Benefits',7,'Payroll_Tax_Superannuation',8,
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',

Line 366: FROM pay_balance_types pbt,

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,
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

Line 381: FROM pay_balance_types pbt,

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,
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

Line 398: FROM pay_balance_types pbt,

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,
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

Line 879: FROM pay_balance_types pbt,

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,
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

Line 896: FROM pay_balance_types pbt,

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,
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

Line 913: FROM pay_balance_types pbt,

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,
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