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 668: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

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

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

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) )

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

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:

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

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);

Line 712: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value

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);

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

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

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

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

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

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;

Line 747: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value

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);

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

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

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

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);

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

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

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

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

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

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

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

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

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

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

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

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

Line 922: 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
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

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

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;

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

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

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

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;

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

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

Line 1048: 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
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;

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

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

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

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

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

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');

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

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

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

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:

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

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;

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

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:

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

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;

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

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;

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

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

Line 1436: 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
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;

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

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