eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_ARC_RSEA_07 dependencies on PAY_BALANCE_PKG

Line 751: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);

747: OPEN csr_LE_addr(l_legal_employer_id);
748: FETCH csr_LE_addr INTO rg_LE_addr;
749: CLOSE csr_LE_addr;
750: --
751: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
752: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));
753: --
754: IF l_local_unit_id IS NOT NULL THEN
755: /* Pick up the Exemption Limit details belonging to Local Unit*/

Line 752: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));

748: FETCH csr_LE_addr INTO rg_LE_addr;
749: CLOSE csr_LE_addr;
750: --
751: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
752: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));
753: --
754: IF l_local_unit_id IS NOT NULL THEN
755: /* Pick up the Exemption Limit details belonging to Local Unit*/
756: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_local_unit_id);

Line 756: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_local_unit_id);

752: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));
753: --
754: IF l_local_unit_id IS NOT NULL THEN
755: /* Pick up the Exemption Limit details belonging to Local Unit*/
756: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_local_unit_id);
757: --
758: OPEN csr_Local_Unit_EA(l_local_unit_id, l_reporting_end_date);
759: FETCH csr_Local_Unit_EA INTO l_el;
760: CLOSE csr_Local_Unit_EA;

Line 767: l_el_a := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

763: FETCH csr_Local_Unit_EL INTO rg_Local_Unit_EL;
764: CLOSE csr_Local_Unit_EL;
765: --
766: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used', '_TU_LU_YTD') ;
767: l_el_a := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
768: l_el_a := nvl(rg_Local_Unit_EL.exempt_limit,0) - nvl(rg_Local_Unit_EL.economic_aid,0) - nvl(l_el_a,0);
769: --
770: OPEN csr_Local_Unit_EL_after( l_local_unit_id , l_reporting_end_date);
771: FETCH csr_Local_Unit_EL_after INTO rg_Local_Unit_EL_after;

Line 775: l_el_b := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

771: FETCH csr_Local_Unit_EL_after INTO rg_Local_Unit_EL_after;
772: CLOSE csr_Local_Unit_EL_after;
773: --
774: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used', '_TU_LU_BIMONTH') ;
775: l_el_b := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
776: l_el_b := l_el_a + nvl(l_el_b,0) + nvl(rg_Local_Unit_EL_after.economic_aid,0);
777: --
778: ELSE
779: /* Pick up the Exemption Limit details belonging to Employer*/

Line 789: l_el_a := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

785: FETCH csr_Legal_Emp_EL INTO rg_Legal_Emp_EL;
786: CLOSE csr_Legal_Emp_EL;
787: --
788: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used', '_TU_YTD') ;
789: l_el_a := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
790: l_el_a := nvl(rg_Legal_Emp_EL.exempt_limit,0) - nvl(rg_Legal_Emp_EL.economic_aid,0) - nvl(l_el_a,0);
791: --
792: OPEN csr_Legal_Emp_EL_after( l_legal_employer_id , l_reporting_end_date);
793: FETCH csr_Legal_Emp_EL_after INTO rg_Legal_Emp_EL_after;

Line 797: l_el_b := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

793: FETCH csr_Legal_Emp_EL_after INTO rg_Legal_Emp_EL_after;
794: CLOSE csr_Legal_Emp_EL_after;
795: --
796: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used', '_TU_BIMONTH') ;
797: l_el_b := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
798: l_el_b := l_el_a + nvl(l_el_b,0) + nvl(rg_Legal_Emp_EL_after.economic_aid,0);
799: --
800: END IF;
801: --

Line 998: pay_balance_pkg.set_context('SOURCE_TEXT2', l_municipal_no);

994: l_municipal_no:=gmunicipaldata(i).municipalcode;
995: --
996: IF l_municipal_no IS NOT NULL THEN
997: --
998: pay_balance_pkg.set_context('SOURCE_TEXT2', l_municipal_no);
999: --
1000: l_sum_tax_value := 0;
1001: /* Setting municipality details for balances*/
1002: OPEN csr_get_mun_dtls(l_municipal_no, l_reporting_end_date);

Line 1011: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);

1007: /* Fetching balance values related to employer contributions report*/
1008: IF l_local_unit_id IS NULL THEN
1009: FOR lu_dtls_rec IN csr_lu_dtls(l_legal_employer_id)
1010: LOOP
1011: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);
1012: l_tax_value := 0;
1013: l_def_bal_id := get_defined_balance_id('Tax','_TU_MC_LU_BIMONTH');
1014: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1015: l_sum_tax_value := l_sum_tax_value + l_tax_value;

Line 1014: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1010: LOOP
1011: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);
1012: l_tax_value := 0;
1013: l_def_bal_id := get_defined_balance_id('Tax','_TU_MC_LU_BIMONTH');
1014: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1015: l_sum_tax_value := l_sum_tax_value + l_tax_value;
1016: END LOOP;
1017: ELSE
1018: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);

Line 1018: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);

1014: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1015: l_sum_tax_value := l_sum_tax_value + l_tax_value;
1016: END LOOP;
1017: ELSE
1018: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1019: l_tax_value := 0;
1020: l_def_bal_id := get_defined_balance_id('Tax','_TU_MC_LU_BIMONTH');
1021: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1022: l_sum_tax_value := l_sum_tax_value + l_tax_value;

Line 1021: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1017: ELSE
1018: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1019: l_tax_value := 0;
1020: l_def_bal_id := get_defined_balance_id('Tax','_TU_MC_LU_BIMONTH');
1021: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1022: l_sum_tax_value := l_sum_tax_value + l_tax_value;
1023: END IF;
1024: --
1025: pay_action_information_api.create_action_information (

Line 1082: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);

1078: l_utr1_amt := 0;
1079: l_utl2_base := 0;
1080: l_utl2_amt := 0;
1081: --
1082: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);
1083: --
1084: -- EC Base
1085: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1086: l_base_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

Line 1086: l_base_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1082: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);
1083: --
1084: -- EC Base
1085: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1086: l_base_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1087: --
1088: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_LU_BIMONTH') ;
1089: l_base_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1090: --

Line 1089: l_base_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1085: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1086: l_base_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1087: --
1088: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_LU_BIMONTH') ;
1089: l_base_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1090: --
1091: -- Reimbursed from SS
1092: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1093: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

Line 1093: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1089: l_base_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1090: --
1091: -- Reimbursed from SS
1092: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1093: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1094: --
1095: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1096: l_reimb_base := l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1097: --

Line 1096: l_reimb_base := l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1092: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1093: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1094: --
1095: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1096: l_reimb_base := l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1097: --
1098: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1099: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1100: --

Line 1099: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1095: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1096: l_reimb_base := l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1097: --
1098: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1099: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1100: --
1101: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed','_TU_LU_BIMONTH') ;
1102: l_reimb_amt := l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1103: --

Line 1102: l_reimb_amt := l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1098: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1099: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1100: --
1101: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed','_TU_LU_BIMONTH') ;
1102: l_reimb_amt := l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1103: --
1104: -- EC Base, Special EC percentage -UTL1
1105: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1106: l_utl1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

Line 1106: l_utl1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1102: l_reimb_amt := l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1103: --
1104: -- EC Base, Special EC percentage -UTL1
1105: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1106: l_utl1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1107: --
1108: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_LU_BIMONTH') ;
1109: l_utl1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1110: --

Line 1109: l_utl1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1105: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1106: l_utl1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1107: --
1108: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_LU_BIMONTH') ;
1109: l_utl1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1110: --
1111: -- Reimbursed from SS, Special EC Percentage - UTR1
1112: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1113: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

Line 1113: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1109: l_utl1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1110: --
1111: -- Reimbursed from SS, Special EC Percentage - UTR1
1112: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1113: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1114: --
1115: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1116: l_utr1_base := l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1117: --

Line 1116: l_utr1_base := l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1112: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1113: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1114: --
1115: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1116: l_utr1_base := l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1117: --
1118: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1119: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1120: --

Line 1119: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1115: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1116: l_utr1_base := l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1117: --
1118: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1119: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1120: --
1121: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Benefit Reimbursed','_TU_LU_BIMONTH') ;
1122: l_utr1_amt := l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1123: --

Line 1122: l_utr1_amt := l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1118: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1119: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1120: --
1121: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Benefit Reimbursed','_TU_LU_BIMONTH') ;
1122: l_utr1_amt := l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1123: --
1124: -- EC Base Special monthly amount - UTL2
1125: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1126: l_utl2_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)/ l_fe_fm_amount;

Line 1126: l_utl2_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)/ l_fe_fm_amount;

1122: l_utr1_amt := l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1123: --
1124: -- EC Base Special monthly amount - UTL2
1125: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1126: l_utl2_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)/ l_fe_fm_amount;
1127: --
1128: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_LU_BIMONTH') ;
1129: l_utl2_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1130: --

Line 1129: l_utl2_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1125: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1126: l_utl2_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)/ l_fe_fm_amount;
1127: --
1128: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_LU_BIMONTH') ;
1129: l_utl2_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1130: --
1131: -- EC Base Pension
1132: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;
1133: l_pension_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

Line 1133: l_pension_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1129: l_utl2_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1130: --
1131: -- EC Base Pension
1132: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;
1133: l_pension_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1134: --
1135: pay_action_information_api.create_action_information (
1136: p_action_information_id => l_action_info_id
1137: ,p_action_context_id => p_payroll_action_id

Line 1187: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);

1183: l_utr1_amt := 0;
1184: l_utl2_base := 0;
1185: l_utl2_amt := 0;
1186: --
1187: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1188: -- EC Base
1189: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1190: l_base_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1191: --

Line 1190: l_base_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1186: --
1187: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1188: -- EC Base
1189: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1190: l_base_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1191: --
1192: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_LU_BIMONTH') ;
1193: l_base_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1194: --

Line 1193: l_base_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1189: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1190: l_base_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1191: --
1192: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_LU_BIMONTH') ;
1193: l_base_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1194: --
1195: -- Reimbursed from SS
1196: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1197: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

Line 1197: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1193: l_base_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1194: --
1195: -- Reimbursed from SS
1196: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1197: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1198: --
1199: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1200: l_reimb_base := l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1201: --

Line 1200: l_reimb_base := l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1196: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1197: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1198: --
1199: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1200: l_reimb_base := l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1201: --
1202: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1203: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1204: --

Line 1203: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1199: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1200: l_reimb_base := l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1201: --
1202: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1203: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1204: --
1205: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed','_TU_LU_BIMONTH') ;
1206: l_reimb_amt := l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1207: --

Line 1206: l_reimb_amt := l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1202: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1203: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1204: --
1205: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed','_TU_LU_BIMONTH') ;
1206: l_reimb_amt := l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1207: --
1208: -- EC Base, Special EC percentage -UTL1
1209: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1210: l_utl1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

Line 1210: l_utl1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1206: l_reimb_amt := l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1207: --
1208: -- EC Base, Special EC percentage -UTL1
1209: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1210: l_utl1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1211: --
1212: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_LU_BIMONTH') ;
1213: l_utl1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1214: --

Line 1213: l_utl1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1209: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1210: l_utl1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1211: --
1212: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_LU_BIMONTH') ;
1213: l_utl1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1214: --
1215: -- Reimbursed from SS, Special EC Percentage - UTR1
1216: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1217: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

Line 1217: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1213: l_utl1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1214: --
1215: -- Reimbursed from SS, Special EC Percentage - UTR1
1216: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1217: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1218: --
1219: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1220: l_utr1_base := l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1221: --

Line 1220: l_utr1_base := l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1216: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1217: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1218: --
1219: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1220: l_utr1_base := l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1221: --
1222: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1223: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1224: --

Line 1223: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1219: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1220: l_utr1_base := l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1221: --
1222: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1223: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1224: --
1225: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Benefit Reimbursed','_TU_LU_BIMONTH') ;
1226: l_utr1_amt := l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1227: --

Line 1226: l_utr1_amt := l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1222: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1223: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1224: --
1225: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Benefit Reimbursed','_TU_LU_BIMONTH') ;
1226: l_utr1_amt := l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1227: --
1228: -- EC Base Special monthly amount - UTL2
1229: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1230: l_utl2_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE) / l_fe_fm_amount;

Line 1230: l_utl2_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE) / l_fe_fm_amount;

1226: l_utr1_amt := l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1227: --
1228: -- EC Base Special monthly amount - UTL2
1229: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1230: l_utl2_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE) / l_fe_fm_amount;
1231: --
1232: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_LU_BIMONTH') ;
1233: l_utl2_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1234: -- EC Base Pension

Line 1233: l_utl2_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1229: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1230: l_utl2_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE) / l_fe_fm_amount;
1231: --
1232: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_LU_BIMONTH') ;
1233: l_utl2_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1234: -- EC Base Pension
1235: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;
1236: l_pension_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1237: --

Line 1236: l_pension_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

1232: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_LU_BIMONTH') ;
1233: l_utl2_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1234: -- EC Base Pension
1235: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;
1236: l_pension_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1237: --
1238: pay_action_information_api.create_action_information (
1239: p_action_information_id => l_action_info_id
1240: ,p_action_context_id => p_payroll_action_id