[Home] [Help]
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',
241: 'Payroll_Tax_Other_Taxable_Payments' )
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
372: AND pbd.balance_dimension_id = pdb.balance_dimension_id
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
387: AND pbd.balance_dimension_id = pdb.balance_dimension_id
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
404: AND pbd.balance_dimension_id = pdb.balance_dimension_id
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
885: AND pbd.balance_dimension_id = pdb.balance_dimension_id
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
902: AND pbd.balance_dimension_id = pdb.balance_dimension_id
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
919: AND pbd.balance_dimension_id = pdb.balance_dimension_id