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.GHR_PAY_CAPS dependencies on STANDARD

Line 710: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

706: --Bug# 5132113
707: --Begin Bug# 7557159
708: ELSIF l_pay_plan in('IG') THEN
709: -- } 1
710: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
711: ,'02'
712: ,'00'
713: ,l_pay_cap_in_data.effective_date);
714: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN

Line 723: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX','02','00'

719: --End Bug# 7557159
720: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','AL','AA','SL','IP','ST','CA','EE', 'FE' ) THEN
721: -- } 1
722: IF l_pay_plan ='FE' THEN --Added for bug#5931199
723: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX','02','00'
724: ,l_pay_cap_in_data.effective_date);
725: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','SL','IP','ST') THEN --Removed FE bug#5931199
726: -- { 2
727: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date) ) THEN

Line 734: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'

730:
731: IF (l_pay_plan in ('ES','EP','EV','IE') ) THEN
732: --Begin Bug# 7633783
733: IF l_pay_cap_in_data.pay_rate_determinant = 'D' THEN
734: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
735: ,'00'
736: ,'00'
737: ,l_pay_cap_in_data.effective_date);
738:

Line 742: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

738:
739: ELSE
740: --End Bug# 7633783
741: --Removed FE bug#5931199
742: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
743: ,'02'
744: ,'00'
745: ,l_pay_cap_in_data.effective_date);
746: hr_utility.set_location('INSIDE EX-02',123456);

Line 754: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value

750: --Begin Bug# 6807868, coded as per the Pay cap master chart
751: --Begin Bug# 7633783 added PRD S
752: --Begin Bug# 8320557
753: IF l_pay_cap_in_data.pay_rate_determinant IN ('R','S') THEN
754: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value
755: ('EX'
756: ,'02'
757: ,'00'
758: ,l_pay_cap_in_data.effective_date);

Line 764: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

760: --End Bug# 6807868
761: --Bug # 8515337 added date effectivity to consider EX-02 only after 12-Apr-2009
762: -- For SL ST IP and Certified Agency
763: IF l_pay_cap_in_data.effective_date >= to_date('2009/04/12','YYYY/MM/DD') THEN
764: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
765: ,'02'
766: ,'00'
767: ,l_pay_cap_in_data.effective_date);
768: ELSE

Line 769: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

765: ,'02'
766: ,'00'
767: ,l_pay_cap_in_data.effective_date);
768: ELSE
769: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
770: ,'03'
771: ,'00'
772: ,l_pay_cap_in_data.effective_date);
773: END IF;

Line 781: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value

777: -- Bug # 8320557 Modified for SL ST IP pay plans to consider EX-02 for PRD R
778: -- and EX-03 for Other than R PRDs and NON Certified
779: IF (l_pay_plan in ('SL','ST','IP') ) THEN
780: IF l_pay_cap_in_data.pay_rate_determinant IN ('R') THEN
781: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value
782: ('EX'
783: ,'02'
784: ,'00'
785: ,l_pay_cap_in_data.effective_date);

Line 787: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

783: ,'02'
784: ,'00'
785: ,l_pay_cap_in_data.effective_date);
786: ELSE
787: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
788: ,'03'
789: ,'00'
790: ,l_pay_cap_in_data.effective_date);
791: END IF;

Line 796: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

792: ELSE
793: --End Bug# 8320557
794: --Begin Bug# 7633783
795: IF l_pay_cap_in_data.pay_rate_determinant = 'D' THEN
796: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
797: ,'01'
798: ,'00'
799: ,l_pay_cap_in_data.effective_date);
800: ELSE

Line 802: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

798: ,'00'
799: ,l_pay_cap_in_data.effective_date);
800: ELSE
801: --End Bug# 7633783
802: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
803: ,'03'
804: ,'00'
805: ,l_pay_cap_in_data.effective_date);
806: END IF;

Line 814: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value

810: ELSIF l_pay_plan in ('AL','AA','CA','EE') THEN
811: -- { 2
812: --Begin Bug# 6807868, coded as per the Pay cap master chart
813: IF l_pay_cap_in_data.pay_rate_determinant = 'R' AND l_pay_plan in ('AL','CA') THEN
814: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value
815: ('EX'
816: ,'02'
817: ,'00'
818: ,l_pay_cap_in_data.effective_date);

Line 821: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value

817: ,'00'
818: ,l_pay_cap_in_data.effective_date);
819: --Begin Bug# 9973337
820: ELSIF l_pay_plan in ('EE') THEN
821: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value
822: ('EX'
823: ,'02'
824: ,'00'
825: ,l_pay_cap_in_data.effective_date);

Line 829: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

825: ,l_pay_cap_in_data.effective_date);
826: -- End Bug# 9973337
827: ELSE
828: --End Bug# 6807868
829: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
830: ,'03'
831: ,'00'
832: ,l_pay_cap_in_data.effective_date);
833: END IF; --Bug# 6807868

Line 878: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

874: (l_pay_plan = 'YJ' AND l_grade_or_level IN ('01','02','03'))
875: ) THEN
876: -- } 1
877: IF l_pay_cap_in_data.pay_rate_determinant IN ('0','4','T') THEN
878: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
879: ,'04'
880: ,'00'
881: ,l_pay_cap_in_data.effective_date);
882: l_pay_cap_amount := FLOOR((l_pay_cap_amount * 105) / 100);

Line 884: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

880: ,'00'
881: ,l_pay_cap_in_data.effective_date);
882: l_pay_cap_amount := FLOOR((l_pay_cap_amount * 105) / 100);
883: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'R' THEN
884: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
885: ,'02'
886: ,'00'
887: ,l_pay_cap_in_data.effective_date);
888: --Begin Bug# 7633783

Line 890: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

886: ,'00'
887: ,l_pay_cap_in_data.effective_date);
888: --Begin Bug# 7633783
889: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'S' THEN
890: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
891: ,'03'
892: ,'00'
893: ,l_pay_cap_in_data.effective_date);
894: --End Bug# 7633783

Line 897: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

893: ,l_pay_cap_in_data.effective_date);
894: --End Bug# 7633783
895: --Begin bug# 8324201
896: ELSIF l_pay_cap_in_data.pay_rate_determinant = '2' AND ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)) THEN
897: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
898: ,'02'
899: ,'00'
900: ,l_pay_cap_in_data.effective_date);
901: --End bug# 8324201

Line 949: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VW'

945: (l_pay_plan = 'YJ' AND l_grade_or_level = '04')
946: ) THEN
947: -- } 1
948: IF l_pay_cap_in_data.pay_rate_determinant IN ('0','4','T','R') THEN
949: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VW'
950: ,'00'
951: ,'00'
952: ,l_pay_cap_in_data.effective_date);
953: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN

Line 1003: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

999: -- } 1
1000: ----Bug 2065033
1001: -- Bug#4168256 Removed Pay Plan EV. Added it with pay plans ES,EP,FE,IE
1002: IF l_pay_plan in ('EX') THEN
1003: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1004: ,'01'
1005: ,'00'
1006: ,l_pay_cap_in_data.effective_date);
1007: --BEGIN Bug# 6807868

Line 1009: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1005: ,'00'
1006: ,l_pay_cap_in_data.effective_date);
1007: --BEGIN Bug# 6807868
1008: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'R' THEN
1009: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1010: ,'02'
1011: ,'00'
1012: ,l_pay_cap_in_data.effective_date);
1013: --END Bug# 6807868

Line 1016: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1012: ,l_pay_cap_in_data.effective_date);
1013: --END Bug# 6807868
1014: --BEGIN Bug# 9255822
1015: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'Y' THEN
1016: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1017: ,'04'
1018: ,'00'
1019: ,l_pay_cap_in_data.effective_date);
1020: l_pay_cap_amount := FLOOR((l_pay_cap_amount * 105) / 100);

Line 1024: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1020: l_pay_cap_amount := FLOOR((l_pay_cap_amount * 105) / 100);
1021: --END Bug# 9255822
1022: --Begin Bug# 7633783
1023: ELSIF l_pay_plan ='GS' AND l_pay_cap_in_data.pay_rate_determinant = 'D' THEN
1024: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1025: ,'01'
1026: ,'00'
1027: ,l_pay_cap_in_data.effective_date);
1028: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'S' THEN

Line 1029: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1025: ,'01'
1026: ,'00'
1027: ,l_pay_cap_in_data.effective_date);
1028: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'S' THEN
1029: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1030: ,'03'
1031: ,'00'
1032: ,l_pay_cap_in_data.effective_date);
1033: --End Bug# 7633783

Line 1035: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1031: ,'00'
1032: ,l_pay_cap_in_data.effective_date);
1033: --End Bug# 7633783
1034: ELSE
1035: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1036: ,'04'
1037: ,'00'
1038: ,l_pay_cap_in_data.effective_date);
1039: END IF;

Line 1087: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1083:
1084: ----Bug 2065033
1085: -- Bug#4168256 Removed Pay Plan EV. Added it with pay plans ES,EP,FE,IE
1086: IF l_pay_plan in ('EX') THEN
1087: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1088: ,'01'
1089: ,'00'
1090: ,l_pay_cap_in_data.effective_date);
1091: ELSE

Line 1094: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1090: ,l_pay_cap_in_data.effective_date);
1091: ELSE
1092: --Bug#4168256 After FWFA, the adj pay cap changed to EX-04.
1093: -- Adj Pay Cap is EX-04 from the begining. Removing the effective date check.
1094: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1095: ,'04'
1096: ,'00'
1097: ,l_pay_cap_in_data.effective_date);
1098: END IF;

Line 1150: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1146: IF (l_au_overtime is not null ) OR (l_availability_pay is not null) THEN
1147: -- Bug# 4168256 Added the IF condition.
1148: IF (pp_gs_equivalent(l_pay_plan))
1149: AND (l_pay_cap_in_data.pay_rate_determinant in ('3','J','K','U','V')) THEN
1150: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1151: ,'04'
1152: ,'00'
1153: ,l_pay_cap_in_data.effective_date);
1154: ELSE

Line 1155: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1151: ,'04'
1152: ,'00'
1153: ,l_pay_cap_in_data.effective_date);
1154: ELSE
1155: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1156: ,'05'
1157: ,'00'
1158: ,l_pay_cap_in_data.effective_date);
1159: END IF;

Line 1190: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1186: l_adj_basic_mesg_flag := 1;
1187: END IF;
1188: ELSIF ( nvl(l_au_overtime,0) = 0 ) AND (nvl(l_availability_pay,0) = 0) THEN
1189:
1190: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1191: ,'04'
1192: ,'00'
1193: ,l_pay_cap_in_data.effective_date);
1194: --check the adjusted basic pay

Line 1229: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1225: hr_utility.set_location('Before entering TPC logic CTS'||l_converted_total_salary,1);
1226: hr_utility.set_location('p_noa_code is '||p_noa_code,1);
1227: --Begin Bug# 7557159
1228: IF l_pay_plan in('IG') THEN
1229: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1230: ,'01'
1231: ,'00'
1232: ,l_pay_cap_in_data.effective_date);
1233: IF l_pay_cap_amount < l_converted_total_salary THEN

Line 1243: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VX',

1239: --End Bug# 7557159
1240: --Bug# 5132113
1241: -- Bug# 7034637
1242: ELSIF l_pay_plan in('GP','GR') THEN
1243: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VX',
1244: '00','00',l_pay_cap_in_data.effective_date);
1245: -- Begin Bug# 7034637
1246: IF l_pay_cap_amount < l_converted_total_salary THEN
1247: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');

Line 1263: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'

1259: --check the total pay
1260: -- Pradeep added this if statement as for EE Pay Plan VZ-00 is the Total Pay Cap.
1261: IF l_pay_plan in ('EE','FE') THEN --Added pay plan FE for bug#5931199
1262:
1263: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1264: ,'00'
1265: ,'00'
1266: ,l_pay_cap_in_data.effective_date);
1267: -- Bug 4063133, 4065855

Line 1275: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'

1271: -- Performance Certification Changes
1272: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)
1273: ) THEN
1274: hr_utility.set_location('INSIDE VZ-02',12345);
1275: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1276: ,'00'
1277: ,'00'
1278: ,l_pay_cap_in_data.effective_date);
1279:

Line 1282: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1278: ,l_pay_cap_in_data.effective_date);
1279:
1280:
1281: ELSE -- not certified then old pay cap limit
1282: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1283: ,'01'
1284: ,'00'
1285: ,l_pay_cap_in_data.effective_date);
1286: END IF;

Line 1292: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'

1288: ELSIF ( l_pay_plan in ( 'SL','ST','IP') ) THEN
1289: -- Bug#5125166 For Certified employees on pay plans SL,ST,IP, pay cap is VZ-00, else EX-01.
1290: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)
1291: ) THEN
1292: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1293: ,'00'
1294: ,'00'
1295: ,l_pay_cap_in_data.effective_date);
1296:

Line 1298: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1294: ,'00'
1295: ,l_pay_cap_in_data.effective_date);
1296:
1297: ELSE -- not certified then old pay cap limit
1298: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1299: ,'01'
1300: ,'00'
1301: ,l_pay_cap_in_data.effective_date);
1302: END IF;

Line 1306: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1302: END IF;
1303:
1304: -- Bug 4063133, 4065855
1305: ELSE
1306: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1307: ,'01'
1308: ,'00'
1309: ,l_pay_cap_in_data.effective_date);
1310: END IF;

Line 1539: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1535: AND (l_pay_plan IN ('YA','YB','YC','YD','YE','YF','YH','YI','YK','YL','YM','YN','YP') OR
1536: (l_pay_plan = 'YJ' AND l_grade_or_level IN ('01','02','03'))
1537: ) THEN
1538: IF l_pay_cap_in_data.pay_rate_determinant IN ('0','4','T') THEN
1539: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1540: ,'01'
1541: ,'00'
1542: ,l_pay_cap_in_data.effective_date);
1543: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'R' THEN

Line 1544: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

1540: ,'01'
1541: ,'00'
1542: ,l_pay_cap_in_data.effective_date);
1543: ELSIF l_pay_cap_in_data.pay_rate_determinant = 'R' THEN
1544: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1545: ,'02'
1546: ,'00'
1547: ,l_pay_cap_in_data.effective_date);
1548: --Begin bug# 8324201

Line 1550: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'

1546: ,'00'
1547: ,l_pay_cap_in_data.effective_date);
1548: --Begin bug# 8324201
1549: ELSIF l_pay_cap_in_data.pay_rate_determinant = '2' AND ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)) THEN
1550: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1551: ,'00'
1552: ,'00'
1553: ,l_pay_cap_in_data.effective_date);
1554: --End bug# 8324201

Line 1576: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VX'

1572: AND (l_pay_plan = 'YG' OR
1573: (l_pay_plan = 'YJ' AND l_grade_or_level = '04')
1574: ) THEN
1575: IF l_pay_cap_in_data.pay_rate_determinant IN ('0','4','T','R') THEN
1576: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VX'
1577: ,'00'
1578: ,'00'
1579: ,l_pay_cap_in_data.effective_date);
1580: IF l_pay_cap_amount < l_converted_total_salary THEN