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 822: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);

818: OPEN csr_LE_addr(l_legal_employer_id);
819: FETCH csr_LE_addr INTO rg_LE_addr;
820: CLOSE csr_LE_addr;
821: --
822: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
823: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));
824: --
825: IF l_local_unit_id IS NOT NULL THEN
826: /* Pick up the Exemption Limit details belonging to Local Unit*/

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

819: FETCH csr_LE_addr INTO rg_LE_addr;
820: CLOSE csr_LE_addr;
821: --
822: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
823: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));
824: --
825: IF l_local_unit_id IS NOT NULL THEN
826: /* Pick up the Exemption Limit details belonging to Local Unit*/
827: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_local_unit_id);

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

823: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));
824: --
825: IF l_local_unit_id IS NOT NULL THEN
826: /* Pick up the Exemption Limit details belonging to Local Unit*/
827: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_local_unit_id);
828: --
829: OPEN csr_Local_Unit_EA(l_local_unit_id, l_reporting_end_date);
830: FETCH csr_Local_Unit_EA INTO l_el;
831: CLOSE csr_Local_Unit_EA;

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

834: FETCH csr_Local_Unit_EL INTO rg_Local_Unit_EL;
835: CLOSE csr_Local_Unit_EL;
836: --
837: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used', '_TU_LU_YTD') ;
838: l_el_a := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
839: l_el_a := nvl(rg_Local_Unit_EL.exempt_limit,0) - nvl(rg_Local_Unit_EL.economic_aid,0) - nvl(l_el_a,0);
840: --
841: OPEN csr_Local_Unit_EL_after( l_local_unit_id , l_reporting_end_date);
842: FETCH csr_Local_Unit_EL_after INTO rg_Local_Unit_EL_after;

Line 847: l_el_b := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE); --14260836

843: CLOSE csr_Local_Unit_EL_after;
844: --
845: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used', l_bal_dim) ; --14260836
846:
847: l_el_b := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE); --14260836
848: l_el_b := l_el_a + nvl(l_el_b,0) + nvl(rg_Local_Unit_EL_after.economic_aid,0);
849: --
850: ELSE
851: /* Pick up the Exemption Limit details belonging to Employer*/

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

857: FETCH csr_Legal_Emp_EL INTO rg_Legal_Emp_EL;
858: CLOSE csr_Legal_Emp_EL;
859: --
860: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used', '_TU_YTD') ;
861: l_el_a := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
862: l_el_a := nvl(rg_Legal_Emp_EL.exempt_limit,0) - nvl(rg_Legal_Emp_EL.economic_aid,0) - nvl(l_el_a,0);
863: --
864: OPEN csr_Legal_Emp_EL_after( l_legal_employer_id , l_reporting_end_date);
865: FETCH csr_Legal_Emp_EL_after INTO rg_Legal_Emp_EL_after;

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

865: FETCH csr_Legal_Emp_EL_after INTO rg_Legal_Emp_EL_after;
866: CLOSE csr_Legal_Emp_EL_after;
867: --
868: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used', '_TU_BIMONTH') ;
869: l_el_b := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
870: l_el_b := l_el_a + nvl(l_el_b,0) + nvl(rg_Legal_Emp_EL_after.economic_aid,0);
871: --
872: END IF;
873: --

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

1077: l_municipal_no:=gmunicipaldata(i).municipalcode;
1078: --
1079: IF l_municipal_no IS NOT NULL THEN
1080: --
1081: pay_balance_pkg.set_context('SOURCE_TEXT2', l_municipal_no);
1082: --
1083: l_sum_tax_value := 0;
1084: /* Setting municipality details for balances*/
1085: OPEN csr_get_mun_dtls(l_municipal_no, l_reporting_end_date);

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

1090: /* Fetching balance values related to employer contributions report*/
1091: IF l_local_unit_id IS NULL THEN
1092: FOR lu_dtls_rec IN csr_lu_dtls(l_legal_employer_id)
1093: LOOP
1094: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);
1095: l_tax_value := 0;
1096: l_def_bal_id := get_defined_balance_id('Tax','_TU_MC_LU_BIMONTH');
1097: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1098: l_sum_tax_value := l_sum_tax_value + l_tax_value;

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

1093: LOOP
1094: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);
1095: l_tax_value := 0;
1096: l_def_bal_id := get_defined_balance_id('Tax','_TU_MC_LU_BIMONTH');
1097: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1098: l_sum_tax_value := l_sum_tax_value + l_tax_value;
1099: END LOOP;
1100: ELSE
1101: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);

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

1097: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1098: l_sum_tax_value := l_sum_tax_value + l_tax_value;
1099: END LOOP;
1100: ELSE
1101: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1102: l_tax_value := 0;
1103: l_def_bal_id := get_defined_balance_id('Tax',l_bal_dim1); --14260836
1104: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE); --14260836
1105: l_sum_tax_value := l_sum_tax_value + l_tax_value;

Line 1104: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE); --14260836

1100: ELSE
1101: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1102: l_tax_value := 0;
1103: l_def_bal_id := get_defined_balance_id('Tax',l_bal_dim1); --14260836
1104: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE); --14260836
1105: l_sum_tax_value := l_sum_tax_value + l_tax_value;
1106: END IF;
1107:
1108: l_sum_tax_value := FLOOR(l_sum_tax_value); --14260836

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

1160: l_utl2_base := 0;
1161: l_utl2_amt := 0;
1162: l_pension_amount := 0;
1163: --
1164: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);
1165: -- bug 16512355
1166: -- EC Base
1167: /* l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1168: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836 */

Line 1168: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836 */

1164: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.lu_id);
1165: -- bug 16512355
1166: -- EC Base
1167: /* l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1168: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836 */
1169: --
1170: l_def_bal_id := get_defined_balance_id('Employer Contribution Base 2','_TU_LU_BIMONTH') ;
1171: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); -- bug 16512355
1172: --

Line 1171: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); -- bug 16512355

1167: /* l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_LU_BIMONTH') ;
1168: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836 */
1169: --
1170: l_def_bal_id := get_defined_balance_id('Employer Contribution Base 2','_TU_LU_BIMONTH') ;
1171: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); -- bug 16512355
1172: --
1173: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_LU_BIMONTH') ;
1174: l_base_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1175: --

Line 1174: l_base_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1170: l_def_bal_id := get_defined_balance_id('Employer Contribution Base 2','_TU_LU_BIMONTH') ;
1171: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); -- bug 16512355
1172: --
1173: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_LU_BIMONTH') ;
1174: l_base_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1175: --
1176: -- Reimbursed from SS
1177: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1178: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

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

1174: l_base_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1175: --
1176: -- Reimbursed from SS
1177: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1178: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1179: --
1180: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1181: l_reimb_base := FLOOR(l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1182: --

Line 1181: l_reimb_base := FLOOR(l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1177: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base','_TU_LU_BIMONTH') ;
1178: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1179: --
1180: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1181: l_reimb_base := FLOOR(l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1182: --
1183: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1184: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1185: --

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

1180: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1181: l_reimb_base := FLOOR(l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1182: --
1183: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1184: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1185: --
1186: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed','_TU_LU_BIMONTH') ;
1187: l_reimb_amt := FLOOR(l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1188: --

Line 1187: l_reimb_amt := FLOOR(l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1183: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1184: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1185: --
1186: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed','_TU_LU_BIMONTH') ;
1187: l_reimb_amt := FLOOR(l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1188: --
1189: -- EC Base, Special EC percentage -UTL1
1190: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1191: l_utl1_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

Line 1191: l_utl1_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1187: l_reimb_amt := FLOOR(l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1188: --
1189: -- EC Base, Special EC percentage -UTL1
1190: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1191: l_utl1_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1192: --
1193: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_LU_BIMONTH') ;
1194: l_utl1_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1195: --

Line 1194: l_utl1_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1190: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_LU_BIMONTH') ;
1191: l_utl1_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1192: --
1193: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_LU_BIMONTH') ;
1194: l_utl1_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1195: --
1196: -- Reimbursed from SS, Special EC Percentage - UTR1
1197: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1198: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);

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

1194: l_utl1_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1195: --
1196: -- Reimbursed from SS, Special EC Percentage - UTR1
1197: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1198: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1199: --
1200: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1201: l_utr1_base := FLOOR(l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1202: --

Line 1201: l_utr1_base := FLOOR(l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1197: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base','_TU_LU_BIMONTH') ;
1198: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1199: --
1200: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1201: l_utr1_base := FLOOR(l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1202: --
1203: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1204: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1205: --

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

1200: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base','_TU_LU_BIMONTH') ;
1201: l_utr1_base := FLOOR(l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1202: --
1203: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1204: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1205: --
1206: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Benefit Reimbursed','_TU_LU_BIMONTH') ;
1207: l_utr1_amt := FLOOR(l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1208: --

Line 1207: l_utr1_amt := FLOOR(l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1203: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed','_TU_LU_BIMONTH') ;
1204: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1205: --
1206: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Benefit Reimbursed','_TU_LU_BIMONTH') ;
1207: l_utr1_amt := FLOOR(l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1208: --
1209: -- EC Base Special monthly amount - UTL2
1210: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1211: l_utl2_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)/ l_fe_fm_amount); --14260836

Line 1211: l_utl2_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)/ l_fe_fm_amount); --14260836

1207: l_utr1_amt := FLOOR(l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1208: --
1209: -- EC Base Special monthly amount - UTL2
1210: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1211: l_utl2_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)/ l_fe_fm_amount); --14260836
1212: --
1213: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_LU_BIMONTH') ;
1214: l_utl2_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1215:

Line 1214: l_utl2_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1210: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base','_TU_LU_BIMONTH') ;
1211: l_utl2_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)/ l_fe_fm_amount); --14260836
1212: --
1213: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_LU_BIMONTH') ;
1214: l_utl2_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1215:
1216: --
1217: -- EC Base Pension
1218: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;

Line 1219: l_pension_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836

1215:
1216: --
1217: -- EC Base Pension
1218: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;
1219: l_pension_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1220: --
1221: --14260836
1222: l_rate := fnd_number.canonical_to_number
1223: (hruserdt.get_table_value

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

1286: l_utl2_base := 0;
1287: l_utl2_amt := 0;
1288: l_pension_amount := 0;
1289: --
1290: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1291: -- EC Base
1292: /* l_def_bal_id := get_defined_balance_id('Employer Contribution Base',l_bal_dim) ; --14260836
1293: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); */ --14260836
1294: --

Line 1293: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); */ --14260836

1289: --
1290: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1291: -- EC Base
1292: /* l_def_bal_id := get_defined_balance_id('Employer Contribution Base',l_bal_dim) ; --14260836
1293: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); */ --14260836
1294: --
1295: l_def_bal_id := get_defined_balance_id('Employer Contribution Base 2',l_bal_dim) ; --16512355
1296: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE));
1297: --

Line 1296: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE));

1292: /* l_def_bal_id := get_defined_balance_id('Employer Contribution Base',l_bal_dim) ; --14260836
1293: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); */ --14260836
1294: --
1295: l_def_bal_id := get_defined_balance_id('Employer Contribution Base 2',l_bal_dim) ; --16512355
1296: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE));
1297: --
1298: l_def_bal_id := get_defined_balance_id('Employer Contribution',l_bal_dim) ; --14260836
1299: l_base_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1300: --

Line 1299: l_base_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1295: l_def_bal_id := get_defined_balance_id('Employer Contribution Base 2',l_bal_dim) ; --16512355
1296: l_base_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE));
1297: --
1298: l_def_bal_id := get_defined_balance_id('Employer Contribution',l_bal_dim) ; --14260836
1299: l_base_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1300: --
1301: -- Reimbursed from SS
1302: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base',l_bal_dim) ; --14260836
1303: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);

Line 1303: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);

1299: l_base_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1300: --
1301: -- Reimbursed from SS
1302: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base',l_bal_dim) ; --14260836
1303: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1304: --
1305: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base',l_bal_dim) ; --14260836
1306: l_reimb_base := FLOOR(l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1307: --

Line 1306: l_reimb_base := FLOOR(l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1302: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed Base',l_bal_dim) ; --14260836
1303: l_reimb_base := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1304: --
1305: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base',l_bal_dim) ; --14260836
1306: l_reimb_base := FLOOR(l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1307: --
1308: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed',l_bal_dim) ; --14260836
1309: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1310: --

Line 1309: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);

1305: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed Base',l_bal_dim) ; --14260836
1306: l_reimb_base := FLOOR(l_reimb_base + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1307: --
1308: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed',l_bal_dim) ; --14260836
1309: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1310: --
1311: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed',l_bal_dim) ; --14260836
1312: l_reimb_amt := FLOOR(l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1313: --

Line 1312: l_reimb_amt := FLOOR(l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1308: l_def_bal_id := get_defined_balance_id('Employer Contribution Holiday Pay Reimbursed',l_bal_dim) ; --14260836
1309: l_reimb_amt := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1310: --
1311: l_def_bal_id := get_defined_balance_id('Employer Contribution Benefit Reimbursed',l_bal_dim) ; --14260836
1312: l_reimb_amt := FLOOR(l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1313: --
1314: -- EC Base, Special EC percentage -UTL1
1315: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base',l_bal_dim) ; --14260836
1316: l_utl1_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

Line 1316: l_utl1_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1312: l_reimb_amt := FLOOR(l_reimb_amt + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1313: --
1314: -- EC Base, Special EC percentage -UTL1
1315: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base',l_bal_dim) ; --14260836
1316: l_utl1_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1317: --
1318: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage',l_bal_dim) ; --14260836
1319: l_utl1_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1320: --

Line 1319: l_utl1_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1315: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base',l_bal_dim) ; --14260836
1316: l_utl1_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1317: --
1318: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage',l_bal_dim) ; --14260836
1319: l_utl1_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1320: --
1321: -- Reimbursed from SS, Special EC Percentage - UTR1
1322: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base',l_bal_dim) ; --14260836
1323: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);

Line 1323: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);

1319: l_utl1_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1320: --
1321: -- Reimbursed from SS, Special EC Percentage - UTR1
1322: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base',l_bal_dim) ; --14260836
1323: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1324: --
1325: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base',l_bal_dim) ; --14260836
1326: l_utr1_base := FLOOR(l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1327: --

Line 1326: l_utr1_base := FLOOR(l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1322: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimb Base',l_bal_dim) ; --14260836
1323: l_utr1_base := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1324: --
1325: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base',l_bal_dim) ; --14260836
1326: l_utr1_base := FLOOR(l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1327: --
1328: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed',l_bal_dim) ; --14260836
1329: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1330: --

Line 1329: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);

1325: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Benefit Reimbursed Base',l_bal_dim) ; --14260836
1326: l_utr1_base := FLOOR(l_utr1_base + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1327: --
1328: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed',l_bal_dim) ; --14260836
1329: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1330: --
1331: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Benefit Reimbursed',l_bal_dim) ; --14260836
1332: l_utr1_amt := FLOOR(l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1333: --

Line 1332: l_utr1_amt := FLOOR(l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1328: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Perc Holiday Pay Reimbursed',l_bal_dim) ; --14260836
1329: l_utr1_amt := pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE);
1330: --
1331: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Benefit Reimbursed',l_bal_dim) ; --14260836
1332: l_utr1_amt := FLOOR(l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1333: --
1334: -- EC Base Special monthly amount - UTL2
1335: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base',l_bal_dim) ; --14260836
1336: l_utl2_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE) / l_fe_fm_amount); --14260836

Line 1336: l_utl2_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE) / l_fe_fm_amount); --14260836

1332: l_utr1_amt := FLOOR(l_utr1_amt + pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1333: --
1334: -- EC Base Special monthly amount - UTL2
1335: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base',l_bal_dim) ; --14260836
1336: l_utl2_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE) / l_fe_fm_amount); --14260836
1337: --
1338: l_def_bal_id := get_defined_balance_id('Employer Contribution Special',l_bal_dim) ; --14260836
1339: l_utl2_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1340:

Line 1339: l_utl2_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1335: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Base',l_bal_dim) ; --14260836
1336: l_utl2_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE) / l_fe_fm_amount); --14260836
1337: --
1338: l_def_bal_id := get_defined_balance_id('Employer Contribution Special',l_bal_dim) ; --14260836
1339: l_utl2_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1340:
1341: -- EC Base Pension
1342: l_def_bal_id := get_defined_balance_id('Employers Pension Premium',l_bal_dim) ; --14260836
1343: l_pension_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

Line 1343: l_pension_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836

1339: l_utl2_amt := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1340:
1341: -- EC Base Pension
1342: l_def_bal_id := get_defined_balance_id('Employers Pension Premium',l_bal_dim) ; --14260836
1343: l_pension_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1344: --
1345: --14260836
1346: l_rate := fnd_number.canonical_to_number
1347: (hruserdt.get_table_value