[Home] [Help]
364: l_pay_cap_amount NUMBER;
365: l_pay_cap_in_data ghr_pay_caps.pay_cap_in_rec_type;
366: l_pay_cap_out_data ghr_pay_caps.pay_cap_out_rec_type;
367:
368: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
369: l_pay_plan VARCHAR2(30);
370:
371: ---- New Variables
372: l_pay_basis VARCHAR2(30);
443: FUNCTION convert_amount_to_PA(p_amount IN NUMBER
444: ,p_pay_basis IN VARCHAR2)
445: RETURN NUMBER IS
446: BEGIN
447: RETURN( ghr_pay_calc.convert_amount(p_amount
448: ,p_pay_basis
449: ,'PA') );
450: EXCEPTION
451: WHEN ghr_pay_calc.pay_calc_message THEN
447: RETURN( ghr_pay_calc.convert_amount(p_amount
448: ,p_pay_basis
449: ,'PA') );
450: EXCEPTION
451: WHEN ghr_pay_calc.pay_calc_message THEN
452: RETURN(NULL);
453: END convert_amount_to_PA;
454: --
455: --
664: --Bug# 5132113
665: --Begin Bug# 7557159
666: ELSIF l_pay_plan in('IG') THEN
667: -- } 1
668: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
669: ,'02'
670: ,'00'
671: ,l_pay_cap_in_data.effective_date);
672: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN
677: --End Bug# 7557159
678: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','AL','AA','SL','IP','ST','CA','EE', 'FE' ) THEN
679: -- } 1
680: IF l_pay_plan ='FE' THEN --Added for bug#5931199
681: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX','02','00'
682: ,l_pay_cap_in_data.effective_date);
683: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','SL','IP','ST') THEN --Removed FE bug#5931199
684: -- { 2
685: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date) )
689:
690: IF (l_pay_plan in ('ES','EP','EV','IE') ) THEN
691: --Begin Bug# 7633783
692: IF l_pay_cap_in_data.pay_rate_determinant = 'D' THEN
693: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
694: ,'00'
695: ,'00'
696: ,l_pay_cap_in_data.effective_date);
697:
697:
698: ELSE
699: --End Bug# 7633783
700: --Removed FE bug#5931199
701: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
702: ,'02'
703: ,'00'
704: ,l_pay_cap_in_data.effective_date);
705: hr_utility.set_location('INSIDE EX-02',123456);
708: ELSIF (l_pay_plan in ('SL','ST','IP') ) THEN
709: --Begin Bug# 6807868, coded as per the Pay cap master chart
710: --Begin Bug# 7633783 added PRD S
711: IF l_pay_cap_in_data.pay_rate_determinant IN ('R','S') THEN
712: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value
713: ('EX'
714: ,'02'
715: ,'00'
716: ,l_pay_cap_in_data.effective_date);
715: ,'00'
716: ,l_pay_cap_in_data.effective_date);
717: ELSE
718: --End Bug# 6807868
719: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
720: ,'03'
721: ,'00'
722: ,l_pay_cap_in_data.effective_date);
723: END IF; -- Bug# 6807868
726: ELSE -- IF NONE OF THE AGENCIES OR ORGANIZATIONS ARE CERTIFIED
727: -- }3
728: --Begin Bug# 7633783
729: IF l_pay_cap_in_data.pay_rate_determinant = 'D' THEN
730: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
731: ,'01'
732: ,'00'
733: ,l_pay_cap_in_data.effective_date);
734: ELSE
732: ,'00'
733: ,l_pay_cap_in_data.effective_date);
734: ELSE
735: --End Bug# 7633783
736: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
737: ,'03'
738: ,'00'
739: ,l_pay_cap_in_data.effective_date);
740: END IF;
743: ELSIF l_pay_plan in ('AL','AA','CA','EE') THEN
744: -- { 2
745: --Begin Bug# 6807868, coded as per the Pay cap master chart
746: IF l_pay_cap_in_data.pay_rate_determinant = 'R' AND l_pay_plan in ('AL','CA') THEN
747: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value
748: ('EX'
749: ,'02'
750: ,'00'
751: ,l_pay_cap_in_data.effective_date);
750: ,'00'
751: ,l_pay_cap_in_data.effective_date);
752: ELSE
753: --End Bug# 6807868
754: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
755: ,'03'
756: ,'00'
757: ,l_pay_cap_in_data.effective_date);
758: END IF; --Bug# 6807868
769: ,p_adj_basic_pay => l_converted_adj_basic_pay
770: ,p_locality_adj => l_converted_locality_adj );
771:
772: if l_to_auo_premium_pay_indicator is not null then
773: l_au_overtime := ghr_pay_calc.get_ppi_amount(
774: l_to_auo_premium_pay_indicator
775: ,l_converted_adj_basic_pay
776: ,l_pay_basis);
777: end if;
775: ,l_converted_adj_basic_pay
776: ,l_pay_basis);
777: end if;
778: if l_to_ap_premium_pay_indicator is not null then
779: l_availability_pay := ghr_pay_calc.get_ppi_amount(
780: l_to_ap_premium_pay_indicator
781: ,l_converted_adj_basic_pay
782: ,l_pay_basis);
783: end if;
799: (l_pay_plan = 'YJ' AND l_grade_or_level IN ('01','02','03'))
800: ) THEN
801: -- } 1
802: IF l_pay_cap_in_data.pay_rate_determinant IN ('0','4','T') THEN
803: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
804: ,'04'
805: ,'00'
806: ,l_pay_cap_in_data.effective_date);
807: l_pay_cap_amount := FLOOR((l_pay_cap_amount * 105) / 100);
805: ,'00'
806: ,l_pay_cap_in_data.effective_date);
807: l_pay_cap_amount := FLOOR((l_pay_cap_amount * 105) / 100);
808: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'R' THEN
809: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
810: ,'02'
811: ,'00'
812: ,l_pay_cap_in_data.effective_date);
813: --Begin Bug# 7633783
811: ,'00'
812: ,l_pay_cap_in_data.effective_date);
813: --Begin Bug# 7633783
814: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'S' THEN
815: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
816: ,'03'
817: ,'00'
818: ,l_pay_cap_in_data.effective_date);
819: --End Bug# 7633783
823: l_converted_locality_adj := l_converted_adj_basic_pay - l_converted_basic_pay;
824:
825: -- Bug 5663050 Start
826: if l_to_auo_premium_pay_indicator is not null then
827: l_au_overtime := ghr_pay_calc.get_ppi_amount(
828: l_to_auo_premium_pay_indicator
829: ,l_converted_adj_basic_pay
830: ,l_pay_basis);
831: end if;
829: ,l_converted_adj_basic_pay
830: ,l_pay_basis);
831: end if;
832: if l_to_ap_premium_pay_indicator is not null then
833: l_availability_pay := ghr_pay_calc.get_ppi_amount(
834: l_to_ap_premium_pay_indicator
835: ,l_converted_adj_basic_pay
836: ,l_pay_basis);
837: end if;
850: (l_pay_plan = 'YJ' AND l_grade_or_level = '04')
851: ) THEN
852: -- } 1
853: IF l_pay_cap_in_data.pay_rate_determinant IN ('0','4','T','R') THEN
854: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VW'
855: ,'00'
856: ,'00'
857: ,l_pay_cap_in_data.effective_date);
858: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN
860: l_converted_locality_adj := l_converted_adj_basic_pay - l_converted_basic_pay;
861:
862: -- Bug 5663050 Start
863: if l_to_auo_premium_pay_indicator is not null then
864: l_au_overtime := ghr_pay_calc.get_ppi_amount(
865: l_to_auo_premium_pay_indicator
866: ,l_converted_adj_basic_pay
867: ,l_pay_basis);
868: end if;
866: ,l_converted_adj_basic_pay
867: ,l_pay_basis);
868: end if;
869: if l_to_ap_premium_pay_indicator is not null then
870: l_availability_pay := ghr_pay_calc.get_ppi_amount(
871: l_to_ap_premium_pay_indicator
872: ,l_converted_adj_basic_pay
873: ,l_pay_basis);
874: end if;
900: -- } 1
901: ----Bug 2065033
902: -- Bug#4168256 Removed Pay Plan EV. Added it with pay plans ES,EP,FE,IE
903: IF l_pay_plan in ('EX') THEN
904: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
905: ,'01'
906: ,'00'
907: ,l_pay_cap_in_data.effective_date);
908: --BEGIN Bug# 6807868
906: ,'00'
907: ,l_pay_cap_in_data.effective_date);
908: --BEGIN Bug# 6807868
909: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'R' THEN
910: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
911: ,'02'
912: ,'00'
913: ,l_pay_cap_in_data.effective_date);
914: --END Bug# 6807868
913: ,l_pay_cap_in_data.effective_date);
914: --END Bug# 6807868
915: --Begin Bug# 7633783
916: ELSIF l_pay_plan ='GS' AND l_pay_cap_in_data.pay_rate_determinant = 'D' THEN
917: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
918: ,'01'
919: ,'00'
920: ,l_pay_cap_in_data.effective_date);
921: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'S' THEN
918: ,'01'
919: ,'00'
920: ,l_pay_cap_in_data.effective_date);
921: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'S' THEN
922: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
923: ,'03'
924: ,'00'
925: ,l_pay_cap_in_data.effective_date);
926: --End Bug# 7633783
924: ,'00'
925: ,l_pay_cap_in_data.effective_date);
926: --End Bug# 7633783
927: ELSE
928: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
929: ,'04'
930: ,'00'
931: ,l_pay_cap_in_data.effective_date);
932: END IF;
938: ,p_adj_basic_pay => l_converted_adj_basic_pay
939: ,p_locality_adj => l_converted_locality_adj );
940:
941: if l_to_auo_premium_pay_indicator is not null then
942: l_au_overtime := ghr_pay_calc.get_ppi_amount(
943: l_to_auo_premium_pay_indicator
944: ,l_converted_adj_basic_pay
945: ,l_pay_basis);
946: end if;
944: ,l_converted_adj_basic_pay
945: ,l_pay_basis);
946: end if;
947: if l_to_ap_premium_pay_indicator is not null then
948: l_availability_pay := ghr_pay_calc.get_ppi_amount(
949: l_to_ap_premium_pay_indicator
950: ,l_converted_adj_basic_pay
951: ,l_pay_basis);
952: end if;
976:
977: ----Bug 2065033
978: -- Bug#4168256 Removed Pay Plan EV. Added it with pay plans ES,EP,FE,IE
979: IF l_pay_plan in ('EX') THEN
980: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
981: ,'01'
982: ,'00'
983: ,l_pay_cap_in_data.effective_date);
984: ELSE
983: ,l_pay_cap_in_data.effective_date);
984: ELSE
985: --Bug#4168256 After FWFA, the adj pay cap changed to EX-04.
986: -- Adj Pay Cap is EX-04 from the begining. Removing the effective date check.
987: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
988: ,'04'
989: ,'00'
990: ,l_pay_cap_in_data.effective_date);
991: END IF;
997: ,p_adj_basic_pay => l_converted_adj_basic_pay
998: ,p_locality_adj => l_converted_locality_adj );
999:
1000: if l_to_auo_premium_pay_indicator is not null then
1001: l_au_overtime := ghr_pay_calc.get_ppi_amount(
1002: l_to_auo_premium_pay_indicator
1003: ,l_converted_adj_basic_pay
1004: ,l_pay_basis);
1005: end if;
1003: ,l_converted_adj_basic_pay
1004: ,l_pay_basis);
1005: end if;
1006: if l_to_ap_premium_pay_indicator is not null then
1007: l_availability_pay := ghr_pay_calc.get_ppi_amount(
1008: l_to_ap_premium_pay_indicator
1009: ,l_converted_adj_basic_pay
1010: ,l_pay_basis);
1011: end if;
1039: IF (l_au_overtime is not null ) OR (l_availability_pay is not null) THEN
1040: -- Bug# 4168256 Added the IF condition.
1041: IF (pp_gs_equivalent(l_pay_plan))
1042: AND (l_pay_cap_in_data.pay_rate_determinant in ('3','J','K','U','V')) THEN
1043: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1044: ,'04'
1045: ,'00'
1046: ,l_pay_cap_in_data.effective_date);
1047: ELSE
1044: ,'04'
1045: ,'00'
1046: ,l_pay_cap_in_data.effective_date);
1047: ELSE
1048: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1049: ,'05'
1050: ,'00'
1051: ,l_pay_cap_in_data.effective_date);
1052: END IF;
1057: ,p_adj_basic_pay => l_converted_adj_basic_pay
1058: ,p_locality_adj => l_converted_locality_adj );
1059:
1060: if l_to_auo_premium_pay_indicator is not null then
1061: l_au_overtime := ghr_pay_calc.get_ppi_amount(
1062: l_to_auo_premium_pay_indicator
1063: ,l_converted_adj_basic_pay
1064: ,l_pay_basis);
1065: end if;
1063: ,l_converted_adj_basic_pay
1064: ,l_pay_basis);
1065: end if;
1066: if l_to_ap_premium_pay_indicator is not null then
1067: l_availability_pay := ghr_pay_calc.get_ppi_amount(
1068: l_to_ap_premium_pay_indicator
1069: ,l_converted_adj_basic_pay
1070: ,l_pay_basis);
1071: end if;
1079: l_adj_basic_mesg_flag := 1;
1080: END IF;
1081: ELSIF ( nvl(l_au_overtime,0) = 0 ) AND (nvl(l_availability_pay,0) = 0) THEN
1082:
1083: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1084: ,'04'
1085: ,'00'
1086: ,l_pay_cap_in_data.effective_date);
1087: --check the adjusted basic pay
1091: ,p_adj_basic_pay => l_converted_adj_basic_pay
1092: ,p_locality_adj => l_converted_locality_adj );
1093:
1094: if l_to_auo_premium_pay_indicator is not null then
1095: l_au_overtime := ghr_pay_calc.get_ppi_amount(
1096: l_to_auo_premium_pay_indicator
1097: ,l_converted_adj_basic_pay
1098: ,l_pay_basis);
1099: end if;
1097: ,l_converted_adj_basic_pay
1098: ,l_pay_basis);
1099: end if;
1100: if l_to_ap_premium_pay_indicator is not null then
1101: l_availability_pay := ghr_pay_calc.get_ppi_amount(
1102: l_to_ap_premium_pay_indicator
1103: ,l_converted_adj_basic_pay
1104: ,l_pay_basis);
1105: end if;
1118: hr_utility.set_location('Before entering TPC logic CTS'||l_converted_total_salary,1);
1119: hr_utility.set_location('p_noa_code is '||p_noa_code,1);
1120: --Begin Bug# 7557159
1121: IF l_pay_plan in('IG') THEN
1122: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1123: ,'01'
1124: ,'00'
1125: ,l_pay_cap_in_data.effective_date);
1126: IF l_pay_cap_amount < l_converted_total_salary THEN
1132: --End Bug# 7557159
1133: --Bug# 5132113
1134: -- Bug# 7034637
1135: ELSIF l_pay_plan in('GP','GR') THEN
1136: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VX',
1137: '00','00',l_pay_cap_in_data.effective_date);
1138: -- Begin Bug# 7034637
1139: IF l_pay_cap_amount < l_converted_total_salary THEN
1140: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');
1151: --check the total pay
1152: -- Pradeep added this if statement as for EE Pay Plan VZ-00 is the Total Pay Cap.
1153: IF l_pay_plan in ('EE','FE') THEN --Added pay plan FE for bug#5931199
1154:
1155: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1156: ,'00'
1157: ,'00'
1158: ,l_pay_cap_in_data.effective_date);
1159: -- Bug 4063133, 4065855
1163: -- Performance Certification Changes
1164: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)
1165: ) THEN
1166: hr_utility.set_location('INSIDE VZ-02',12345);
1167: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1168: ,'00'
1169: ,'00'
1170: ,l_pay_cap_in_data.effective_date);
1171:
1170: ,l_pay_cap_in_data.effective_date);
1171:
1172:
1173: ELSE -- not certified then old pay cap limit
1174: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1175: ,'01'
1176: ,'00'
1177: ,l_pay_cap_in_data.effective_date);
1178: END IF;
1180: ELSIF ( l_pay_plan in ( 'SL','ST','IP') ) THEN
1181: -- Bug#5125166 For Certified employees on pay plans SL,ST,IP, pay cap is VZ-00, else EX-01.
1182: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)
1183: ) THEN
1184: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1185: ,'00'
1186: ,'00'
1187: ,l_pay_cap_in_data.effective_date);
1188:
1186: ,'00'
1187: ,l_pay_cap_in_data.effective_date);
1188:
1189: ELSE -- not certified then old pay cap limit
1190: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1191: ,'01'
1192: ,'00'
1193: ,l_pay_cap_in_data.effective_date);
1194: END IF;
1194: END IF;
1195:
1196: -- Bug 4063133, 4065855
1197: ELSE
1198: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1199: ,'01'
1200: ,'00'
1201: ,l_pay_cap_in_data.effective_date);
1202: END IF;
1290: l_adjust_op_amt := l_converted_total_salary - l_pay_cap_amount;
1291: if l_adjust_op_amt < 0 then
1292: l_adjust_op_amt := l_adjust_op_amt * -1;
1293: end if;
1294: l_adjust_op_amt := ghr_pay_calc.convert_amount(l_adjust_op_amt
1295: , 'PA'
1296: ,l_pay_basis);
1297:
1298: l_temp_ret_allowance := l_retention_allowance;
1296: ,l_pay_basis);
1297:
1298: l_temp_ret_allowance := l_retention_allowance;
1299: -- Bug#3228580 Added Call to convert the Amount into the corresponding pay basis.
1300: l_difference := ghr_pay_calc.convert_amount(l_converted_total_salary - l_pay_cap_amount
1301: , 'PA'
1302: ,l_pay_basis);
1303:
1304: if l_difference > nvl(l_temp_ret_allowance,0) then
1334: -- Capped other pay should be converted to original pays basis as it is calculated on PA pay basis.
1335: IF NVL(p_other_pay_amount,0) = 0 THEN
1336: l_capped_other_pay := NULL;
1337: ELSE
1338: l_capped_other_pay := ghr_pay_calc.convert_amount(l_pay_cap_amount - l_converted_adj_basic_pay
1339: , 'PA'
1340: , l_pay_basis);
1341: END IF;
1342: -- l_capped_other_pay := l_pay_cap_amount - l_converted_adj_basic_pay;
1344: end if;
1345:
1346: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1347: -- Bug#3228580 Added Call to convert the Amount into the corresponding pay basis.
1348: l_difference := ghr_pay_calc.convert_amount(l_converted_total_salary - l_pay_cap_amount
1349: , 'PA'
1350: ,l_pay_basis);
1351: l_converted_total_salary := l_pay_cap_amount;
1352:
1427: AND (l_pay_plan IN ('YA','YB','YC','YD','YE','YF','YH','YI','YK','YL','YM','YN','YP') OR
1428: (l_pay_plan = 'YJ' AND l_grade_or_level IN ('01','02','03'))
1429: ) THEN
1430: IF l_pay_cap_in_data.pay_rate_determinant IN ('0','4','T') THEN
1431: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1432: ,'01'
1433: ,'00'
1434: ,l_pay_cap_in_data.effective_date);
1435: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'R' THEN
1432: ,'01'
1433: ,'00'
1434: ,l_pay_cap_in_data.effective_date);
1435: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'R' THEN
1436: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1437: ,'02'
1438: ,'00'
1439: ,l_pay_cap_in_data.effective_date);
1440: END IF;
1449: AND (l_pay_plan = 'YG' OR
1450: (l_pay_plan = 'YJ' AND l_grade_or_level = '04')
1451: ) THEN
1452: IF l_pay_cap_in_data.pay_rate_determinant IN ('0','4','T','R') THEN
1453: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VX'
1454: ,'00'
1455: ,'00'
1456: ,l_pay_cap_in_data.effective_date);
1457: IF l_pay_cap_amount < l_converted_total_salary THEN
1463: -- Bug 5663050 End
1464: END IF;
1465:
1466: if l_update34_date is not null AND p_effective_date >= l_update34_date then
1467: p_locality_adj := ghr_pay_calc.convert_amount(l_converted_locality_adj
1468: , 'PA'
1469: ,l_pay_basis);
1470: else
1471: p_locality_adj := l_converted_locality_adj;
1469: ,l_pay_basis);
1470: else
1471: p_locality_adj := l_converted_locality_adj;
1472: end if;
1473: p_adj_basic_pay := ghr_pay_calc.convert_amount(l_converted_adj_basic_pay
1474: , 'PA'
1475: ,l_pay_basis);
1476: p_total_salary := ghr_pay_calc.convert_amount(l_converted_total_salary
1477: , 'PA'
1472: end if;
1473: p_adj_basic_pay := ghr_pay_calc.convert_amount(l_converted_adj_basic_pay
1474: , 'PA'
1475: ,l_pay_basis);
1476: p_total_salary := ghr_pay_calc.convert_amount(l_converted_total_salary
1477: , 'PA'
1478: ,l_pay_basis);
1479: if nvl(l_capped_other_pay,0) = nvl(l_other_pay_amount,0) then
1480: p_capped_other_pay := NULL;
1572: -- Initialization of out and in out parameters in case of exceptions raised by
1573: -- non 810 actions
1574: IF l_non_810_error THEN
1575: IF l_update34_date is not null AND p_effective_date >= l_update34_date THEN
1576: p_locality_adj := ghr_pay_calc.convert_amount(l_converted_locality_adj
1577: , 'PA'
1578: ,l_pay_basis);
1579: ELSE
1580: p_locality_adj := l_converted_locality_adj;
1578: ,l_pay_basis);
1579: ELSE
1580: p_locality_adj := l_converted_locality_adj;
1581: END IF;
1582: p_adj_basic_pay := ghr_pay_calc.convert_amount(l_converted_adj_basic_pay
1583: , 'PA'
1584: ,l_pay_basis);
1585: p_total_salary := ghr_pay_calc.convert_amount(l_converted_total_salary
1586: , 'PA'
1581: END IF;
1582: p_adj_basic_pay := ghr_pay_calc.convert_amount(l_converted_adj_basic_pay
1583: , 'PA'
1584: ,l_pay_basis);
1585: p_total_salary := ghr_pay_calc.convert_amount(l_converted_total_salary
1586: , 'PA'
1587: ,l_pay_basis);
1588: if nvl(l_capped_other_pay,0) = nvl(l_other_pay_amount,0) then
1589: p_capped_other_pay := NULL;
1610: END IF;
1611: END IF;
1612: END IF;
1613: EXCEPTION
1614: WHEN ghr_pay_calc.pay_calc_message THEN
1615: null;
1616: END do_pay_caps_main;
1617: --
1618: --