[Home] [Help]
605:
606: -- Begin
607: /*
608: select Balance_Type_id Into Lv_Balance_Type_id
609: from Pay_Balance_Types
610: Where Balance_Name = 'Lump Sum C Deductions'
611: and Legislation_code = 'AU';
612:
613:
811: and paa.payroll_action_id=ppa.payroll_action_id;
812:
813: begin
814: select Balance_Type_id Into Lv_Balance_Type_id_1
815: from Pay_Balance_Types
816: Where Balance_Name = 'Invalidity Payments Transitional Not Part of Prev Term'
817: and Legislation_code = 'AU';
818:
819: select Balance_Type_id Into Lv_Balance_Type_id_2
816: Where Balance_Name = 'Invalidity Payments Transitional Not Part of Prev Term'
817: and Legislation_code = 'AU';
818:
819: select Balance_Type_id Into Lv_Balance_Type_id_2
820: from Pay_Balance_Types
821: Where Balance_Name = 'Invalidity Payments Transitional Part of Prev Term'
822: and Legislation_code = 'AU';
823:
824:
893:
894: begin
895:
896: select Balance_Type_id Into Lv_Balance_Type_id_1
897: from Pay_Balance_Types
898: Where Balance_Name = 'ETP Tax Free Payments Excluded'
899: and Legislation_code = 'AU';
900:
901: select Balance_Type_id Into Lv_Balance_Type_id_2
898: Where Balance_Name = 'ETP Tax Free Payments Excluded'
899: and Legislation_code = 'AU';
900:
901: select Balance_Type_id Into Lv_Balance_Type_id_2
902: from Pay_Balance_Types
903: Where Balance_Name = 'ETP Taxable Payments Excluded'
904: and Legislation_code = 'AU';
905:
906: /* Start 9322314 - Modified the logic in the function for calculating the taxable and tax free ETP components
907: for terminated employees processed before and after applying the patch 8769345, such that
908: the all values are reported correctly in the termination report */
909:
910: select Balance_Type_id Into Lv_Balance_Type_id_3
911: from Pay_Balance_Types
912: Where Balance_Name = 'ETP Payments Excluded'
913: and Legislation_code = 'AU';
914:
915: