[Home] [Help]
439: ) sort_index, -- end 8711855
440: pdb.defined_balance_id defined_balance_id
441: from pay_balance_types pbt
442: , pay_balance_dimensions pbd
443: , pay_defined_balances pdb
444: where pbt.balance_name in ( 'CDEP'
445: , 'Leave Payments Marginal'
446: , 'Lump Sum A Deductions'
447: , 'Lump Sum A Payments'
505: , 'Lump Sum C Payments',13) sort_index,
506: pdb.defined_balance_id defined_balance_id
507: from pay_balance_types pbt
508: , pay_balance_dimensions pbd
509: , pay_defined_balances pdb
510: where pbt.balance_name in ('ETP Payments Transitional Not Part of Prev Term'
511: ,'ETP Payments Transitional Part of Prev Term'
512: ,'ETP Payments Life Benefit Not Part of Prev Term'
513: ,'ETP Payments Life Benefit Part of Prev Term'
535: , 'ETP Deductions Excluded Part of Prev',5) sort_index,
536: pdb.defined_balance_id defined_balance_id
537: from pay_balance_types pbt
538: , pay_balance_dimensions pbd
539: , pay_defined_balances pdb
540: where pbt.balance_name in (
541: 'ETP Tax Free Payments Excluded'
542: , 'ETP Taxable Payments Excluded'
543: , 'Invalidity Payments'
556: , 'ETP Deductions Non Excluded Part of Prev', 4) sort_index,
557: pdb.defined_balance_id defined_balance_id
558: from pay_balance_types pbt
559: , pay_balance_dimensions pbd
560: , pay_defined_balances pdb
561: where pbt.balance_name in (
562: 'ETP Tax Free Payments Non Excluded'
563: , 'ETP Taxable Payments Non Excluded'
564: , 'ETP Deductions Non Excluded'
624: ,'Retro Pre Tax GT 12 Mths Amount', 4
625: ,'Retro Earnings Additional GT 12 Mths Amount', 5) sort_index -- bug 13362286
626: , pdb.defined_balance_id defined_balance_id
627: FROM pay_balance_types pbt,
628: pay_defined_balances pdb,
629: pay_balance_dimensions pbd
630: WHERE pbt.legislation_code = 'AU'
631: AND pbt.balance_name in ( 'Lump Sum E Payments'
632: ,'Retro Earnings Leave Loading GT 12 Mths Amount'
727: cursor c_get_fw_alw_bal_type_id is
728: SELECT pbt.balance_type_id,
729: pbt.balance_name
730: FROM pay_balance_attributes pba
731: ,pay_defined_balances pdb
732: ,pay_balance_types pbt
733: ,pay_balance_dimensions pbd
734: WHERE pba.attribute_id = g_attribute_id
735: AND pdb.defined_balance_id = pba.defined_balance_id
1485:
1486: Cursor c_fbt_balance is
1487: select pdb.defined_balance_id
1488: from pay_balance_types pbt,
1489: pay_defined_balances pdb,
1490: pay_balance_dimensions pbd
1491: where pbt.balance_name ='Fringe Benefits'
1492: and pbt.balance_type_id = pdb.balance_type_id
1493: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
2186: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
2187: ,p_registered_employer in NUMBER
2188: ,p_database_item_name in ff_database_items.user_name%TYPE
2189: ,p_balance_name in pay_balance_types.balance_name%TYPE
2190: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
2191: ,p_year_start in DATE
2192: ,p_year_end in DATE
2193: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
2194: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2203:
2204: -------------------------------------------------------------------+
2205: -- Cursor to calculate balances for a given database item
2206: -- To calculate balances we require defined balance id and
2207: -- that can be retrieved only from pay_defined_balances
2208: -- first cursor is to retrive Fringe Benefits Balance
2209: -- second cursor is to retrive other Balance values
2210: -------------------------------------------------------------------+
2211: -- cursors modified for bug #1768813
2224: p_max_assignment_action_id,
2225: p_registered_employer,
2226: null,null,null,null) --2610141
2227: from pay_balance_types pbt,
2228: pay_defined_balances pdb,
2229: pay_balance_dimensions pbd
2230: where pbt.balance_name = c_balance_name
2231: and pbt.legislation_code = 'AU'
2232: and pbt.balance_type_id = pdb.balance_type_id
2722: ,pay_element_types_f pet
2723: /* below added for bug 7571001 */
2724: ,PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
2725: , PAY_BALANCE_ATTRIBUTES pba
2726: ,pay_defined_balances pdb
2727: ,pay_balance_dimensions pbd
2728: ,PAY_BALANCE_FEEDS_F pbf
2729: ,pay_input_values_f piv
2730: WHERE paa.assignment_id = c_assignment_id
2762: ;
2763:
2764:
2765: Cursor Get_Retro_allowances(c_element_entry_id pay_element_entries_f.element_entry_id%type,
2766: c_balance_type_id pay_defined_balances.defined_balance_id%type)
2767: IS
2768: select NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
2769: ,prv.result_value balance_value
2770: from
3109: , 'Earnings_Total',2
3110: , 'Standard_Tax_Deductions',3
3111: , 'Foreign Worker Days',4
3112: ) sort_index
3113: FROM pay_defined_balances pdb
3114: ,pay_balance_dimensions pbd
3115: ,pay_balance_types pbt
3116: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
3117: AND pbd.dimension_name = '_ASG_LE_PTD'
3287: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
3288: ,p_fw_alw_bal_exist in varchar2
3289: ) is
3290:
3291: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
3292: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
3293: from pay_defined_balances pdb,
3294: pay_balance_types pbt
3295: where pdb.defined_balance_id = c_defined_balance_id
3289: ) is
3290:
3291: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
3292: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
3293: from pay_defined_balances pdb,
3294: pay_balance_types pbt
3295: where pdb.defined_balance_id = c_defined_balance_id
3296: and pdb.balance_type_id = pbt.balance_type_id
3297: and pdb.business_group_id = g_business_group_id;
4206: ,p_max_assignment_action_id
4207: ,p_registered_employer
4208: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL) balance_value
4209: FROM pay_balance_attributes pba
4210: ,pay_defined_balances pdb
4211: ,pay_balance_types pbt
4212: ,pay_balance_dimensions pbd
4213: WHERE pba.attribute_id = g_attribute_id
4214: AND pdb.defined_balance_id = pba.defined_balance_id
4646: , pbt.balance_type_id bal_type_id
4647: from pay_element_types_f pet
4648: , per_all_assignments_f paa
4649: , pay_balance_types pbt
4650: , pay_defined_balances pdb
4651: , pay_payroll_actions ppa
4652: , pay_assignment_actions pac
4653: , pay_run_results prr
4654: , pay_balance_feeds_f pbf
4965: /*CURSOR union_def_bal_id
4966: IS
4967: SELECT pdb.defined_balance_id
4968: FROM pay_balance_types pbt
4969: ,pay_defined_balances pdb
4970: ,pay_balance_dimensions pbd
4971: WHERE pbt.balance_name = 'Union Fees'
4972: AND pbt.legislation_code = 'AU'
4973: AND pbd.legislation_code = 'AU'
5442: procedure archive_prepost_details
5443: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5444: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5445: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5446: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5447: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
5448: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
5449: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
5450: ,p_date_start in per_periods_of_service.date_start%TYPE
5979: procedure archive_prepost_details_2012
5980: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5981: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5982: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5983: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5984: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
5985: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
5986: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
5987: ,p_date_start in per_periods_of_service.date_start%TYPE
8090: (c_assignment_id in pay_assignment_actions.assignment_id%type
8091: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659
8092: ,c_year_start in pay_payroll_actions.effective_date%type
8093: ,c_year_end in pay_payroll_actions.effective_date%type
8094: ,c_def_bal_id in pay_defined_balances.defined_balance_id%type
8095: ,c_business_group_id in pay_payroll_actions.business_group_id%type
8096: ) is
8097: select distinct nvl(current_employee_flag,'N') current_employee_flag,
8098: actual_termination_date,
8162: -------------------------------------------------+
8163: cursor balance_exists is
8164: select pdb.defined_balance_id
8165: from pay_balance_types pbt,
8166: pay_defined_balances pdb,
8167: pay_balance_dimensions pbd
8168: where pbt.balance_name ='Lump Sum C Payments'
8169: and pbt.legislation_code = g_legislation_code
8170: and pbt.balance_type_id = pdb.balance_type_id