[Home] [Help]
338: , 'Invalidity Payments Transitional Part of Prev Term',25) sort_index, /*4015082 ,6192381 */
339: pdb.defined_balance_id defined_balance_id
340: from pay_balance_types pbt
341: , pay_balance_dimensions pbd
342: , pay_defined_balances pdb
343: where pbt.balance_name in ( 'CDEP'
344: , 'Leave Payments Marginal'
345: , 'Lump Sum A Deductions'
346: , 'Lump Sum A Payments'
381: , 'Lump Sum C Payments',5) 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 ('ETP Payments Transitional Not Part of Prev Term'
387: ,'ETP Payments Transitional Part of Prev Term'
388: ,'ETP Payments Life Benefit Not Part of Prev Term'
389: ,'ETP Payments Life Benefit Part of Prev Term'
964:
965: Cursor c_fbt_balance is
966: select pdb.defined_balance_id
967: from pay_balance_types pbt,
968: pay_defined_balances pdb,
969: pay_balance_dimensions pbd
970: where pbt.balance_name ='Fringe Benefits'
971: and pbt.balance_type_id = pdb.balance_type_id
972: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
1322: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
1323: ,p_registered_employer in NUMBER
1324: ,p_database_item_name in ff_database_items.user_name%TYPE
1325: ,p_balance_name in pay_balance_types.balance_name%TYPE
1326: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
1327: ,p_year_start in DATE
1328: ,p_year_end in DATE
1329: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
1330: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1338:
1339: -------------------------------------------------------------------+
1340: -- Cursor to calculate balances for a given database item
1341: -- To calculate balances we require defined balance id and
1342: -- that can be retrieved only from pay_defined_balances
1343: -- first cursor is to retrive Fringe Benefits Balance
1344: -- second cursor is to retrive other Balance values
1345: -------------------------------------------------------------------+
1346: -- cursors modified for bug #1768813
1359: p_max_assignment_action_id,
1360: p_registered_employer,
1361: null,null,null,null) --2610141
1362: from pay_balance_types pbt,
1363: pay_defined_balances pdb,
1364: pay_balance_dimensions pbd
1365: where pbt.balance_name = c_balance_name
1366: and pbt.legislation_code = 'AU'
1367: and pbt.balance_type_id = pdb.balance_type_id
1395: c_assignment_action_id,
1396: p_registered_employer,
1397: null,null,null,null)) --2610141
1398: FROM pay_balance_types pbt,
1399: pay_defined_balances pdb,
1400: pay_balance_dimensions pbd
1401: WHERE pbt.legislation_code = 'AU'
1402: AND pbt.balance_name = 'Lump Sum E Payments'
1403: AND pbt.balance_type_id = pdb.balance_type_id
2070: , pbt.balance_type_id bal_type_id
2071: from pay_element_types_f pet
2072: , per_all_assignments_f paa
2073: , pay_balance_types pbt
2074: , pay_defined_balances pdb
2075: --, pay_balance_dimensions pbd
2076: --, per_periods_of_service pps
2077: , pay_payroll_actions ppa
2078: , pay_assignment_actions pac
2438: , pbt.balance_type_id bal_type_id
2439: from pay_element_types_f pet
2440: , per_all_assignments_f paa
2441: , pay_balance_types pbt
2442: , pay_defined_balances pdb
2443: , pay_payroll_actions ppa
2444: , pay_assignment_actions pac
2445: , pay_run_results prr
2446: , pay_balance_feeds_f pbf
2692: /*CURSOR union_def_bal_id
2693: IS
2694: SELECT pdb.defined_balance_id
2695: FROM pay_balance_types pbt
2696: ,pay_defined_balances pdb
2697: ,pay_balance_dimensions pbd
2698: WHERE pbt.balance_name = 'Union Fees'
2699: AND pbt.legislation_code = 'AU'
2700: AND pbd.legislation_code = 'AU'
3149: procedure archive_prepost_details
3150: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
3151: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
3152: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
3153: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
3157: ,p_date_start in per_periods_of_service.date_start%TYPE
4625: (c_assignment_id in pay_assignment_actions.assignment_id%type
4626: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659
4627: ,c_year_start in pay_payroll_actions.effective_date%type
4628: ,c_year_end in pay_payroll_actions.effective_date%type
4629: ,c_def_bal_id in pay_defined_balances.defined_balance_id%type
4630: ,c_business_group_id in pay_payroll_actions.business_group_id%type
4631: ) is
4632: select distinct nvl(current_employee_flag,'N') current_employee_flag,
4633: actual_termination_date,
4693: -------------------------------------------------+
4694: cursor balance_exists is
4695: select pdb.defined_balance_id
4696: from pay_balance_types pbt,
4697: pay_defined_balances pdb,
4698: pay_balance_dimensions pbd
4699: where pbt.balance_name ='Lump Sum C Payments'
4700: and pbt.balance_type_id = pdb.balance_type_id
4701: and pdb.balance_dimension_id = pbd.balance_dimension_id --2501105