[Home] [Help]
288: g_debug boolean;
289: g_business_group_id number;
290: g_package constant varchar2(30) := 'pay_au_payment_summary';
291: g_legislation_code constant varchar2(2) := 'AU';
292: g_dimension_id pay_balance_dimensions.balance_dimension_id%type;
293: g_balance_type_id pay_balance_types.balance_type_id%type; /*Bug#5591993*/
294: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
295: g_attribute_id pay_balance_attributes.attribute_id%type; -- bug 7571001
296: g_termination_type varchar2(4); /*Bug#8315198 - Variable to store the termination type*/
438: , 'ETP Deductions Non Excluded Part of Prev',39 /* end bug 14703826 */
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'
504: , 'ETP Taxable Payments Life Benefit Part of Prev Term',12
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'
534: , 'ETP Deductions Excluded',4
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'
555: , 'ETP Deductions Non Excluded',3
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'
577: ** Moved here to avoid having to be executed for each assignment
578: */
579: cursor c_le_ytd_dimension_id is
580: select balance_dimension_id
581: from pay_balance_dimensions pbd
582: where pbd.dimension_name = '_ASG_LE_YTD'
583: and pbd.legislation_code = g_legislation_code;
584: /*Bug#5591993*/
585: -- Cursor to fetch the balance type id for Seeded balance Union Fees which will be
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'
633: ,'Retro Earnings Spread GT 12 Mths Amount'
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
736: AND pbt.balance_type_id = pdb.balance_type_id
737: AND pdb.business_group_id = g_business_group_id
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 */
1494: and pbd.legislation_code ='AU'
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
2233: and pbd.balance_dimension_id = pdb.balance_dimension_id
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
2731: /* start added for bug 7571001 */
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'
3118: AND pbd.legislation_code = 'AU'
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
4215: AND pbt.balance_type_id = pdb.balance_type_id
4216: AND pdb.balance_type_id = pbt.balance_type_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'
4974: AND pbt.balance_type_id = pdb.balance_type_id
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
8171: and pdb.balance_dimension_id = pbd.balance_dimension_id --2501105