[Home] [Help]
29: ,element_name pay_element_types_f.element_name%TYPE
30: ,element_type VARCHAR2(1)
31: ,main_index NUMBER
32: ,archive_flag VARCHAR2(1)
33: ,standard pay_element_types_f.element_name%TYPE
34: ,special pay_element_types_f.element_name%TYPE
35: ,standard2 pay_element_types_f.element_name%TYPE
36: ,special2 pay_element_types_f.element_name%TYPE
37: ,payable_flag VARCHAR2(1));
31: ,main_index NUMBER
32: ,archive_flag VARCHAR2(1)
33: ,standard pay_element_types_f.element_name%TYPE
34: ,special pay_element_types_f.element_name%TYPE
35: ,standard2 pay_element_types_f.element_name%TYPE
36: ,special2 pay_element_types_f.element_name%TYPE
37: ,payable_flag VARCHAR2(1));
38:
39:
1028: g_stat_element_table(1).element_name := NULL;
1029: g_stat_element_table(1).element_type := 'E';
1030: g_stat_element_table(1).main_index := 10000;
1031: g_stat_element_table(1).archive_flag := 'Y';
1032: g_stat_element_table(1).standard := 'Subject to Standard Tax : Earnings';
1033: g_stat_element_table(1).special := 'Subject to Special Tax : Earnings';
1034: g_stat_element_table(1).payable_flag := 'Y';
1035: -- Section 3
1036: g_stat_element_table(2).classification_name := 'Imputed Earnings';
1037: g_stat_element_table(2).element_name := NULL;
1038: g_stat_element_table(2).element_type := NULL;
1039: g_stat_element_table(2).main_index := 12000;
1040: g_stat_element_table(2).archive_flag := 'Y';
1041: g_stat_element_table(2).standard := 'SI Income Subject to Standard Tax : Imputed Earnings';
1042: g_stat_element_table(2).special := 'SI Income Subject to Special Tax : Imputed Earnings';
1043: g_stat_element_table(2).standard2 := 'Subject to Standard Tax : Imputed Earnings';
1044: g_stat_element_table(2).special2 := 'Subject to Special Tax : Imputed Earnings';
1045: g_stat_element_table(2).payable_flag := 'N';
1039: g_stat_element_table(2).main_index := 12000;
1040: g_stat_element_table(2).archive_flag := 'Y';
1041: g_stat_element_table(2).standard := 'SI Income Subject to Standard Tax : Imputed Earnings';
1042: g_stat_element_table(2).special := 'SI Income Subject to Special Tax : Imputed Earnings';
1043: g_stat_element_table(2).standard2 := 'Subject to Standard Tax : Imputed Earnings';
1044: g_stat_element_table(2).special2 := 'Subject to Special Tax : Imputed Earnings';
1045: g_stat_element_table(2).payable_flag := 'N';
1046:
1047: -- Section 4
1049: g_stat_element_table(3).element_name := NULL;
1050: g_stat_element_table(3).element_type := 'D';
1051: g_stat_element_table(3).main_index := 13000;
1052: g_stat_element_table(3).archive_flag := 'Y';
1053: g_stat_element_table(3).standard := 'SI Income Standard Deduction : Pre-SI and Pre-Tax Deductions';
1054: g_stat_element_table(3).special := 'SI Income Special Deduction : Pre-SI and Pre-Tax Deductions';
1055: g_stat_element_table(3).payable_flag := 'Y';
1056:
1057: -- Section 11
1059: g_stat_element_table(4).element_name := NULL;
1060: g_stat_element_table(4).element_type := 'D';
1061: g_stat_element_table(4).main_index := 20000;
1062: g_stat_element_table(4).archive_flag := 'Y';
1063: g_stat_element_table(4).standard := 'Standard Tax Deduction : Pre-Tax Deductions';
1064: g_stat_element_table(4).special := 'Special Tax Deduction : Pre-Tax Deductions';
1065: g_stat_element_table(4).payable_flag := 'Y';
1066:
1067: -- Section 11
1069: g_stat_element_table(5).element_name := NULL;
1070: g_stat_element_table(5).element_type := NULL;
1071: g_stat_element_table(5).main_index := 14500;
1072: g_stat_element_table(5).archive_flag := 'Y';
1073: g_stat_element_table(5).standard := 'Standard Tax Reduction : Reductions';
1074: g_stat_element_table(5).special := 'Special Tax Reduction : Reductions';
1075: g_stat_element_table(5).standard2 := 'SI Income Standard Tax Reduction : Reductions';
1076: g_stat_element_table(5).special2 := 'SI Income Special Tax Reduction : Reductions';
1077: g_stat_element_table(5).payable_flag := 'N';
1071: g_stat_element_table(5).main_index := 14500;
1072: g_stat_element_table(5).archive_flag := 'Y';
1073: g_stat_element_table(5).standard := 'Standard Tax Reduction : Reductions';
1074: g_stat_element_table(5).special := 'Special Tax Reduction : Reductions';
1075: g_stat_element_table(5).standard2 := 'SI Income Standard Tax Reduction : Reductions';
1076: g_stat_element_table(5).special2 := 'SI Income Special Tax Reduction : Reductions';
1077: g_stat_element_table(5).payable_flag := 'N';
1078:
1079: --Section 12a
1077: g_stat_element_table(5).payable_flag := 'N';
1078:
1079: --Section 12a
1080: g_stat_element_table(6).classification_name := 'Earnings';
1081: g_stat_element_table(6).element_name := 'Employer ZVW Contribution Standard Tax';
1082: g_stat_element_table(6).element_type := 'E';
1083: g_stat_element_table(6).main_index := 18700;
1084: g_stat_element_table(6).archive_flag := 'N';
1085: g_stat_element_table(6).standard := 'Subject to Standard Tax : Earnings';
1081: g_stat_element_table(6).element_name := 'Employer ZVW Contribution Standard Tax';
1082: g_stat_element_table(6).element_type := 'E';
1083: g_stat_element_table(6).main_index := 18700;
1084: g_stat_element_table(6).archive_flag := 'N';
1085: g_stat_element_table(6).standard := 'Subject to Standard Tax : Earnings';
1086: g_stat_element_table(6).special := '';
1087: g_stat_element_table(6).payable_flag := 'Y';
1088:
1089: --Section 12b
1091: g_stat_element_table(7).element_name := 'Employer ZVW Contribution Special Tax';
1092: g_stat_element_table(7).element_type := 'E';
1093: g_stat_element_table(7).main_index := 18700;
1094: g_stat_element_table(7).archive_flag := 'N';
1095: g_stat_element_table(7).standard := '';
1096: g_stat_element_table(7).special := 'Subject to Special Tax : Earnings';
1097: g_stat_element_table(7).payable_flag := 'Y';
1098:
1099: -- Section 14a
1097: g_stat_element_table(7).payable_flag := 'Y';
1098:
1099: -- Section 14a
1100: g_stat_element_table(8).classification_name := 'Employee Tax';
1101: g_stat_element_table(8).element_name := 'Standard Tax Deduction';
1102: g_stat_element_table(8).element_type := 'D';
1103: g_stat_element_table(8).main_index := 23000;
1104: g_stat_element_table(8).archive_flag := 'N';
1105: g_stat_element_table(8).standard := '';
1101: g_stat_element_table(8).element_name := 'Standard Tax Deduction';
1102: g_stat_element_table(8).element_type := 'D';
1103: g_stat_element_table(8).main_index := 23000;
1104: g_stat_element_table(8).archive_flag := 'N';
1105: g_stat_element_table(8).standard := '';
1106: g_stat_element_table(8).special := '';
1107: g_stat_element_table(8).payable_flag := 'Y';
1108: -- Section 14b
1109: g_stat_element_table(9).classification_name := 'Employee Tax';
1110: g_stat_element_table(9).element_name := 'Special Tax Deduction';
1111: g_stat_element_table(9).element_type := 'D';
1112: g_stat_element_table(9).main_index := 24000;
1113: g_stat_element_table(9).archive_flag := 'N';
1114: g_stat_element_table(9).standard := '';
1115: g_stat_element_table(9).special := '';
1116: g_stat_element_table(9).payable_flag := 'Y';
1117: -- Section 14c
1118: g_stat_element_table(10).classification_name := 'Employee Tax';
1119: g_stat_element_table(10).element_name := 'Beneficial Rule Special Tax Adjustment';
1120: g_stat_element_table(10).element_type := 'D';
1121: g_stat_element_table(10).main_index := 25000;
1122: g_stat_element_table(10).archive_flag := 'N';
1123: g_stat_element_table(10).standard := '';
1124: g_stat_element_table(10).special := '';
1125: g_stat_element_table(10).payable_flag := 'Y';
1126: --
1127: -- Bug 6447814 starts
1130: g_stat_element_table(11).element_name := NULL;
1131: g_stat_element_table(11).element_type := 'D';
1132: g_stat_element_table(11).main_index := 25100;
1133: g_stat_element_table(11).archive_flag := 'N';
1134: g_stat_element_table(11).standard := '';
1135: g_stat_element_table(11).special := '';
1136: g_stat_element_table(11).payable_flag := 'Y';
1137: -- Bug 6447814 Ends
1138: --
1141: g_stat_element_table(12).element_name := NULL;
1142: g_stat_element_table(12).element_type := 'D';
1143: g_stat_element_table(12).main_index := 26000;
1144: g_stat_element_table(12).archive_flag := 'Y';
1145: g_stat_element_table(12).standard := '';
1146: g_stat_element_table(12).special := '';
1147: g_stat_element_table(12).payable_flag := 'Y';
1148: -- Section 16
1149: g_stat_element_table(13).classification_name := 'Voluntary Deductions';
1150: g_stat_element_table(13).element_name := NULL;
1151: g_stat_element_table(13).element_type := 'D';
1152: g_stat_element_table(13).main_index := 27000;
1153: g_stat_element_table(13).archive_flag := 'Y';
1154: g_stat_element_table(13).standard := '';
1155: g_stat_element_table(13).special := '';
1156: g_stat_element_table(13).payable_flag := 'Y';
1157: -- Section 17
1158: g_stat_element_table(14).classification_name := 'Net Earnings';
1159: g_stat_element_table(14).element_name := NULL;
1160: g_stat_element_table(14).element_type := 'E';
1161: g_stat_element_table(14).main_index := 28000;
1162: g_stat_element_table(14).archive_flag := 'Y';
1163: g_stat_element_table(14).standard := '';
1164: g_stat_element_table(14).special := '';
1165: g_stat_element_table(14).payable_flag := 'Y';
1166:
1167: -- Section 1
1169: g_stat_element_table(15).element_name := NULL;
1170: g_stat_element_table(15).element_type := 'E';
1171: g_stat_element_table(15).main_index := 10500;
1172: g_stat_element_table(15).archive_flag := 'Y';
1173: g_stat_element_table(15).standard := 'Subject to Standard Tax : Retro Earnings';
1174: g_stat_element_table(15).special := 'Subject to Special Tax : Retro Earnings';
1175: g_stat_element_table(15).payable_flag := 'Y';
1176: -- Section 3
1177: g_stat_element_table(16).classification_name := 'Retro Imputed Earnings';
1178: g_stat_element_table(16).element_name := NULL;
1179: g_stat_element_table(16).element_type := NULL;
1180: g_stat_element_table(16).main_index := 12500;
1181: g_stat_element_table(16).archive_flag := 'Y';
1182: g_stat_element_table(16).standard := 'SI Income Subject to Standard Tax : Retro Imputed Earnings';
1183: g_stat_element_table(16).special := 'SI Income Subject to Special Tax : Retro Imputed Earnings';
1184: g_stat_element_table(16).standard2 := 'Subject to Standard Tax : Retro Imputed Earnings';
1185: g_stat_element_table(16).special2 := 'Subject to Special Tax : Retro Imputed Earnings';
1186: g_stat_element_table(16).payable_flag := 'N';
1180: g_stat_element_table(16).main_index := 12500;
1181: g_stat_element_table(16).archive_flag := 'Y';
1182: g_stat_element_table(16).standard := 'SI Income Subject to Standard Tax : Retro Imputed Earnings';
1183: g_stat_element_table(16).special := 'SI Income Subject to Special Tax : Retro Imputed Earnings';
1184: g_stat_element_table(16).standard2 := 'Subject to Standard Tax : Retro Imputed Earnings';
1185: g_stat_element_table(16).special2 := 'Subject to Special Tax : Retro Imputed Earnings';
1186: g_stat_element_table(16).payable_flag := 'N';
1187:
1188: -- Section 4
1190: g_stat_element_table(17).element_name := NULL;
1191: g_stat_element_table(17).element_type := 'D';
1192: g_stat_element_table(17).main_index := 13500;
1193: g_stat_element_table(17).archive_flag := 'Y';
1194: g_stat_element_table(17).standard := 'SI Income Standard Tax : Retro Pre SI and Pre Tax Deductions';
1195: g_stat_element_table(17).special := 'SI Income Special Tax : Retro Pre SI and Pre Tax Deductions';
1196: g_stat_element_table(17).payable_flag := 'Y';
1197:
1198: -- Section 11
1200: g_stat_element_table(18).element_name := NULL;
1201: g_stat_element_table(18).element_type := 'D';
1202: g_stat_element_table(18).main_index := 20500;
1203: g_stat_element_table(18).archive_flag := 'Y';
1204: g_stat_element_table(18).standard := 'Standard Tax Deduction : Retro Pre Tax Deductions';
1205: g_stat_element_table(18).special := 'Special Tax Deduction : Retro Pre Tax Deductions';
1206: g_stat_element_table(18).payable_flag := 'Y';
1207:
1208: g_stat_element_table(19).classification_name := 'Retro Reductions';
1209: g_stat_element_table(19).element_name := NULL;
1210: g_stat_element_table(19).element_type := NULL;
1211: g_stat_element_table(19).main_index := 14600;
1212: g_stat_element_table(19).archive_flag := 'Y';
1213: g_stat_element_table(19).standard := 'Standard Tax Reduction : Retro Reductions';
1214: g_stat_element_table(19).special := 'Special Tax Reduction : Retro Reductions';
1215: g_stat_element_table(19).standard2 := 'SI Income Standard Tax Reduction : Retro Reductions';
1216: g_stat_element_table(19).special2 := 'SI Income Special Tax Reduction : Retro Reductions';
1217: g_stat_element_table(19).payable_flag := 'N';
1211: g_stat_element_table(19).main_index := 14600;
1212: g_stat_element_table(19).archive_flag := 'Y';
1213: g_stat_element_table(19).standard := 'Standard Tax Reduction : Retro Reductions';
1214: g_stat_element_table(19).special := 'Special Tax Reduction : Retro Reductions';
1215: g_stat_element_table(19).standard2 := 'SI Income Standard Tax Reduction : Retro Reductions';
1216: g_stat_element_table(19).special2 := 'SI Income Special Tax Reduction : Retro Reductions';
1217: g_stat_element_table(19).payable_flag := 'N';
1218:
1219: -- Section 12a
1217: g_stat_element_table(19).payable_flag := 'N';
1218:
1219: -- Section 12a
1220: g_stat_element_table(20).classification_name := 'Retro Earnings';
1221: g_stat_element_table(20).element_name := 'Retro Employer ZVW Contribution Standard Tax';
1222: g_stat_element_table(20).element_type := 'E';
1223: g_stat_element_table(20).main_index := 18750;
1224: g_stat_element_table(20).archive_flag := 'N';
1225: g_stat_element_table(20).standard := 'Subject to Standard Tax : Retro Earnings';
1221: g_stat_element_table(20).element_name := 'Retro Employer ZVW Contribution Standard Tax';
1222: g_stat_element_table(20).element_type := 'E';
1223: g_stat_element_table(20).main_index := 18750;
1224: g_stat_element_table(20).archive_flag := 'N';
1225: g_stat_element_table(20).standard := 'Subject to Standard Tax : Retro Earnings';
1226: g_stat_element_table(20).special := '';
1227: g_stat_element_table(20).payable_flag := 'Y';
1228:
1229: -- Section 12a
1231: g_stat_element_table(21).element_name := 'Retro Employer ZVW Contribution Special Tax';
1232: g_stat_element_table(21).element_type := 'E';
1233: g_stat_element_table(21).main_index := 18750;
1234: g_stat_element_table(21).archive_flag := 'N';
1235: g_stat_element_table(21).standard := '';
1236: g_stat_element_table(21).special := 'Subject to Special Tax : Retro Earnings';
1237: g_stat_element_table(21).payable_flag := 'Y';
1238:
1239: -- Section 14a
1237: g_stat_element_table(21).payable_flag := 'Y';
1238:
1239: -- Section 14a
1240: g_stat_element_table(22).classification_name := 'Retro Employee Deductions';
1241: g_stat_element_table(22).element_name := 'Retro Standard Tax Deduction';
1242: g_stat_element_table(22).element_type := 'D';
1243: g_stat_element_table(22).main_index := 23500;
1244: g_stat_element_table(22).archive_flag := 'N';
1245: g_stat_element_table(22).standard := '';
1241: g_stat_element_table(22).element_name := 'Retro Standard Tax Deduction';
1242: g_stat_element_table(22).element_type := 'D';
1243: g_stat_element_table(22).main_index := 23500;
1244: g_stat_element_table(22).archive_flag := 'N';
1245: g_stat_element_table(22).standard := '';
1246: g_stat_element_table(22).special := '';
1247: g_stat_element_table(22).payable_flag := 'Y';
1248: -- Section 14a
1249: g_stat_element_table(23).classification_name := 'Retro Employee Deductions';
1246: g_stat_element_table(22).special := '';
1247: g_stat_element_table(22).payable_flag := 'Y';
1248: -- Section 14a
1249: g_stat_element_table(23).classification_name := 'Retro Employee Deductions';
1250: g_stat_element_table(23).element_name := 'Retro Standard Tax Deduction Current Quarter';
1251: g_stat_element_table(23).element_type := 'D';
1252: g_stat_element_table(23).main_index := 23500;
1253: g_stat_element_table(23).archive_flag := 'N';
1254: g_stat_element_table(23).standard := '';
1250: g_stat_element_table(23).element_name := 'Retro Standard Tax Deduction Current Quarter';
1251: g_stat_element_table(23).element_type := 'D';
1252: g_stat_element_table(23).main_index := 23500;
1253: g_stat_element_table(23).archive_flag := 'N';
1254: g_stat_element_table(23).standard := '';
1255: g_stat_element_table(23).special := '';
1256: g_stat_element_table(23).payable_flag := 'Y';
1257:
1258: -- Section 14b
1260: g_stat_element_table(24).element_name := 'Retro Special Tax Deduction';
1261: g_stat_element_table(24).element_type := 'D';
1262: g_stat_element_table(24).main_index := 24500;
1263: g_stat_element_table(24).archive_flag := 'N';
1264: g_stat_element_table(24).standard := '';
1265: g_stat_element_table(24).special := '';
1266: g_stat_element_table(24).payable_flag := 'Y';
1267: -- Section 14c
1268: g_stat_element_table(25).classification_name := 'Retro Employee Deductions';
1269: g_stat_element_table(25).element_name := 'Retro Beneficial Rule Special Tax Adjustment';
1270: g_stat_element_table(25).element_type := 'D';
1271: g_stat_element_table(25).main_index := 25500;
1272: g_stat_element_table(25).archive_flag := 'N';
1273: g_stat_element_table(25).standard := '';
1274: g_stat_element_table(25).special := '';
1275: g_stat_element_table(25).payable_flag := 'Y';
1276:
1277: -- Bug 5957039
1280: g_stat_element_table(26).element_name := NULL;
1281: g_stat_element_table(26).element_type := 'E';
1282: g_stat_element_table(26).main_index := 18720; --10980;
1283: g_stat_element_table(26).archive_flag := 'Y';
1284: g_stat_element_table(26).standard := NULL; --'Subject to Standard Tax : Earnings';
1285: g_stat_element_table(26).special := NULL; --'Subject to Special Tax : Earnings';
1286: g_stat_element_table(26).payable_flag := 'Y';
1287:
1288: g_stat_element_table(27).classification_name := 'Retro Pre-Tax ZVW Refund';
1289: g_stat_element_table(27).element_name := NULL;
1290: g_stat_element_table(27).element_type := 'E';
1291: g_stat_element_table(27).main_index := 18770; --10990;
1292: g_stat_element_table(27).archive_flag := 'Y';
1293: g_stat_element_table(27).standard := NULL; --'Subject to Standard Tax : Retro Earnings';
1294: g_stat_element_table(27).special := NULL; --'Subject to Special Tax : Retro Earnings';
1295: g_stat_element_table(27).payable_flag := 'Y';
1296:
1297: --5957039
1300: g_stat_element_table(28).element_name := NULL;
1301: g_stat_element_table(28).element_type := 'E';
1302: g_stat_element_table(28).main_index := 28050; --10980;
1303: g_stat_element_table(28).archive_flag := 'Y';
1304: g_stat_element_table(28).standard := NULL; --'Subject to Standard Tax : Earnings';
1305: g_stat_element_table(28).special := NULL; --'Subject to Special Tax : Earnings';
1306: g_stat_element_table(28).payable_flag := 'Y';
1307:
1308: g_stat_element_table(29).classification_name := 'Retro Pre-Tax ZVW Refund';
1309: g_stat_element_table(29).element_name := NULL;
1310: g_stat_element_table(29).element_type := 'E';
1311: g_stat_element_table(29).main_index := 28100; --10990;
1312: g_stat_element_table(29).archive_flag := 'Y';
1313: g_stat_element_table(29).standard := NULL; --'Subject to Standard Tax : Retro Earnings';
1314: g_stat_element_table(29).special := NULL; --'Subject to Special Tax : Retro Earnings';
1315: g_stat_element_table(29).payable_flag := 'Y';
1316:
1317: -- Bug 5957039
1600: AND prv1.run_result_id = prv.run_result_id
1601: AND piv1.name = 'SI Type'
1602: AND prv.result_value IS NOT NULL
1603: AND pet.element_name IN
1604: ('Net Employee SI Contribution', 'Employee SI Contribution Standard Tax',
1605: 'Employee SI Contribution Special Tax', 'Employee SI Contribution');
1606:
1607: --
1608: CURSOR csr_emp_phc_applies(p_assgn_action_id NUMBER
2691: ,p_date_earned IN DATE
2692: ,p_index IN NUMBER
2693: ,p_type IN VARCHAR2
2694: ,p_archive_flag IN VARCHAR2
2695: ,p_standard IN VARCHAR2
2696: ,p_special IN VARCHAR2
2697: ,p_standard2 IN VARCHAR2
2698: ,p_special2 IN VARCHAR2
2699: ,p_payable_flag IN VARCHAR2
2693: ,p_type IN VARCHAR2
2694: ,p_archive_flag IN VARCHAR2
2695: ,p_standard IN VARCHAR2
2696: ,p_special IN VARCHAR2
2697: ,p_standard2 IN VARCHAR2
2698: ,p_special2 IN VARCHAR2
2699: ,p_payable_flag IN VARCHAR2
2700: ,p_record_count IN NUMBER
2701: ,p_master_assign_action_id IN NUMBER
2860: WHERE pscf.element_type_id = p_element_type_id
2861: AND pscf.classification_id = pec.classification_id
2862: AND pec.classification_name
2863: IN
2864: ('Pension Standard Tax : Pre-SI and Pre-Tax Deductions'
2865: ,'Pension Special Tax : Pre-SI and Pre-Tax Deductions'
2866: ,'Pension Standard Tax : Retro Pre SI Pre Tax Deductions'
2867: ,'Pension Special Tax : Retro Pre SI Pre Tax Deductions'
2868: )
2862: AND pec.classification_name
2863: IN
2864: ('Pension Standard Tax : Pre-SI and Pre-Tax Deductions'
2865: ,'Pension Special Tax : Pre-SI and Pre-Tax Deductions'
2866: ,'Pension Standard Tax : Retro Pre SI Pre Tax Deductions'
2867: ,'Pension Special Tax : Retro Pre SI Pre Tax Deductions'
2868: )
2869: AND pec.legislation_code = 'NL'
2870: AND p_date_earned BETWEEN pscf.effective_start_date
2936:
2937: l_temp NUMBER;
2938: l_action_info_id NUMBER;
2939: l_ovn NUMBER;
2940: l_standard_rate varchar2(255);
2941: l_special_rate varchar2(255);
2942: l_payable varchar2(255);
2943: l_defined_balance_id NUMBER;
2944: l_rate NUMBER;
2946: l_temp_index NUMBER;
2947: l_travel_flag NUMBER;
2948: l_retro_travel_flag NUMBER;
2949: l_pecentage_rate pay_run_result_values.result_value%TYPE;
2950: l_sum_standard_rate varchar2(255);
2951: l_sum_special_rate varchar2(255);
2952: l_sum_payable varchar2(255);
2953: l_date varchar2(60);
2954: l_priority NUMBER;
2987: FETCH csr_sec_classification INTO l_retro_travel_flag;
2988: CLOSE csr_sec_classification;
2989:
2990: IF element_value_rec.element_name <> 'Employer ZVW Contribution Special Tax' AND
2991: element_value_rec.element_name <> 'Employer ZVW Contribution Standard Tax' AND
2992: element_value_rec.element_name <> 'Retro Employer ZVW Contribution Special Tax' AND
2993: element_value_rec.element_name <> 'Retro Employer ZVW Contribution Standard Tax' AND
2994: element_value_rec.element_name <> 'Standard Tax Deduction' AND
2995: element_value_rec.element_name <> 'Special Tax Deduction' AND
2989:
2990: IF element_value_rec.element_name <> 'Employer ZVW Contribution Special Tax' AND
2991: element_value_rec.element_name <> 'Employer ZVW Contribution Standard Tax' AND
2992: element_value_rec.element_name <> 'Retro Employer ZVW Contribution Special Tax' AND
2993: element_value_rec.element_name <> 'Retro Employer ZVW Contribution Standard Tax' AND
2994: element_value_rec.element_name <> 'Standard Tax Deduction' AND
2995: element_value_rec.element_name <> 'Special Tax Deduction' AND
2996: element_value_rec.element_name <> 'Beneficial Rule Special Tax Adjustment' THEN
2997:
2990: IF element_value_rec.element_name <> 'Employer ZVW Contribution Special Tax' AND
2991: element_value_rec.element_name <> 'Employer ZVW Contribution Standard Tax' AND
2992: element_value_rec.element_name <> 'Retro Employer ZVW Contribution Special Tax' AND
2993: element_value_rec.element_name <> 'Retro Employer ZVW Contribution Standard Tax' AND
2994: element_value_rec.element_name <> 'Standard Tax Deduction' AND
2995: element_value_rec.element_name <> 'Special Tax Deduction' AND
2996: element_value_rec.element_name <> 'Beneficial Rule Special Tax Adjustment' THEN
2997:
2998: --
2995: element_value_rec.element_name <> 'Special Tax Deduction' AND
2996: element_value_rec.element_name <> 'Beneficial Rule Special Tax Adjustment' THEN
2997:
2998: --
2999: IF p_standard IS NOT NULL THEN
3000: OPEN csr_sec_classification(element_value_rec.element_type_id
3001: ,p_standard
3002: ,p_date_earned);
3003: FETCH csr_sec_classification INTO l_temp;
2997:
2998: --
2999: IF p_standard IS NOT NULL THEN
3000: OPEN csr_sec_classification(element_value_rec.element_type_id
3001: ,p_standard
3002: ,p_date_earned);
3003: FETCH csr_sec_classification INTO l_temp;
3004: IF csr_sec_classification%FOUND THEN
3005: l_standard_rate := element_value_rec.value;
3001: ,p_standard
3002: ,p_date_earned);
3003: FETCH csr_sec_classification INTO l_temp;
3004: IF csr_sec_classification%FOUND THEN
3005: l_standard_rate := element_value_rec.value;
3006: ELSE
3007: l_standard_rate :=NULL;
3008: END IF;
3009: CLOSE csr_sec_classification;
3003: FETCH csr_sec_classification INTO l_temp;
3004: IF csr_sec_classification%FOUND THEN
3005: l_standard_rate := element_value_rec.value;
3006: ELSE
3007: l_standard_rate :=NULL;
3008: END IF;
3009: CLOSE csr_sec_classification;
3010: END IF;
3011:
3008: END IF;
3009: CLOSE csr_sec_classification;
3010: END IF;
3011:
3012: IF p_standard2 IS NOT NULL AND l_standard_rate is NULL THEN
3013: OPEN csr_sec_classification(element_value_rec.element_type_id
3014: ,p_standard2
3015: ,p_date_earned);
3016: FETCH csr_sec_classification INTO l_temp;
3010: END IF;
3011:
3012: IF p_standard2 IS NOT NULL AND l_standard_rate is NULL THEN
3013: OPEN csr_sec_classification(element_value_rec.element_type_id
3014: ,p_standard2
3015: ,p_date_earned);
3016: FETCH csr_sec_classification INTO l_temp;
3017: IF csr_sec_classification%FOUND THEN
3018: l_standard_rate := element_value_rec.value;
3014: ,p_standard2
3015: ,p_date_earned);
3016: FETCH csr_sec_classification INTO l_temp;
3017: IF csr_sec_classification%FOUND THEN
3018: l_standard_rate := element_value_rec.value;
3019: IF p_class_name = 'Imputed Earnings' THEN
3020: l_index := 15800;
3021: END IF;
3022: IF p_class_name = 'Retro Imputed Earnings' THEN
3022: IF p_class_name = 'Retro Imputed Earnings' THEN
3023: l_index := 15900;
3024: END IF;
3025: ELSE
3026: l_standard_rate :=NULL;
3027: END IF;
3028: CLOSE csr_sec_classification;
3029: END IF;
3030:
3066: OPEN csr_sec_classification_psi_ptx(element_value_rec.element_type_id
3067: ,p_date_earned);
3068: FETCH csr_sec_classification_psi_ptx INTO l_classification_name;
3069: IF csr_sec_classification_psi_ptx%FOUND THEN
3070: IF l_classification_name like '%Standard%' THEN
3071: l_standard_rate := element_value_rec.value;
3072: ELSIF l_classification_name like '%Special%' THEN
3073: l_special_rate := element_value_rec.value;
3074: END IF;
3067: ,p_date_earned);
3068: FETCH csr_sec_classification_psi_ptx INTO l_classification_name;
3069: IF csr_sec_classification_psi_ptx%FOUND THEN
3070: IF l_classification_name like '%Standard%' THEN
3071: l_standard_rate := element_value_rec.value;
3072: ELSIF l_classification_name like '%Special%' THEN
3073: l_special_rate := element_value_rec.value;
3074: END IF;
3075: ELSE
3072: ELSIF l_classification_name like '%Special%' THEN
3073: l_special_rate := element_value_rec.value;
3074: END IF;
3075: ELSE
3076: IF l_classification_name like '%Standard%' THEN
3077: l_standard_rate := NULL;
3078: ELSIF l_classification_name like '%Special%' THEN
3079: l_special_rate := NULL;
3080: END IF;
3073: l_special_rate := element_value_rec.value;
3074: END IF;
3075: ELSE
3076: IF l_classification_name like '%Standard%' THEN
3077: l_standard_rate := NULL;
3078: ELSIF l_classification_name like '%Special%' THEN
3079: l_special_rate := NULL;
3080: END IF;
3081: END IF;
3193: END IF;
3194: END IF;
3195: --
3196: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2123);
3197: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_standard_rate) is not null
3198: OR FND_NUMBER.canonical_to_number(l_special_rate) is not null
3199: OR FND_NUMBER.canonical_to_number(l_payable) is not null
3200: OR l_rate is not null) THEN
3201: -- Archive NL CALCULATIONS
3226: ,p_action_information6 =>element_value_rec.reporting_name
3227: ,p_action_information7 =>l_pecentage_rate
3228: ,p_action_information8 =>p_type
3229: ,p_action_information9 =>element_value_rec.RDate --Retro Period
3230: ,p_action_information10 =>l_standard_rate
3231: ,p_action_information11 =>l_special_rate
3232: ,p_action_information12 =>l_payable
3233: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate)
3234: ,p_action_information16 =>l_element_type_id /* 4389520*/
3295: hr_utility.set_location('Retro Inside archive_payslip_element_info1 retro_date'||l_element_retro_entries(i),2123);
3296:
3297: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
3298: FOR j in l_creator_type.first..l_creator_type.last LOOP
3299: l_sum_standard_rate :='0';
3300: l_sum_special_rate :='0';
3301: l_sum_payable :='0';
3302: l_rate :=NULL;
3303:
3300: l_sum_special_rate :='0';
3301: l_sum_payable :='0';
3302: l_rate :=NULL;
3303:
3304: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_standard_rate'||l_sum_standard_rate,2124);
3305: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_special_rate'||l_sum_special_rate,2124);
3306: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2124);
3307:
3308: FOR csr_np_rec IN csr_np_children(
3325:
3326: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'retro_element_value_rec.value'||' '||retro_element_value_rec.value);
3327:
3328: hr_utility.set_location('Retro Inside archive_payslip_element_info1 element_name'||retro_element_value_rec.value,2125);
3329: l_standard_rate:='0';
3330: l_special_rate:='0';
3331: l_payable:='0';
3332:
3333: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard'||' '||p_standard);
3329: l_standard_rate:='0';
3330: l_special_rate:='0';
3331: l_payable:='0';
3332:
3333: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard'||' '||p_standard);
3334: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2126);
3335: IF p_standard IS NOT NULL THEN
3336: OPEN csr_sec_classification(retro_element_value_rec.element_type_id
3337: ,p_standard
3331: l_payable:='0';
3332:
3333: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard'||' '||p_standard);
3334: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2126);
3335: IF p_standard IS NOT NULL THEN
3336: OPEN csr_sec_classification(retro_element_value_rec.element_type_id
3337: ,p_standard
3338: ,p_date_earned);
3339: FETCH csr_sec_classification INTO l_temp;
3333: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard'||' '||p_standard);
3334: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2126);
3335: IF p_standard IS NOT NULL THEN
3336: OPEN csr_sec_classification(retro_element_value_rec.element_type_id
3337: ,p_standard
3338: ,p_date_earned);
3339: FETCH csr_sec_classification INTO l_temp;
3340: IF csr_sec_classification%FOUND THEN
3341: l_standard_rate := retro_element_value_rec.value;
3337: ,p_standard
3338: ,p_date_earned);
3339: FETCH csr_sec_classification INTO l_temp;
3340: IF csr_sec_classification%FOUND THEN
3341: l_standard_rate := retro_element_value_rec.value;
3342: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
3343: ELSE
3344: l_standard_rate :=NULL;
3345: END IF;
3338: ,p_date_earned);
3339: FETCH csr_sec_classification INTO l_temp;
3340: IF csr_sec_classification%FOUND THEN
3341: l_standard_rate := retro_element_value_rec.value;
3342: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
3343: ELSE
3344: l_standard_rate :=NULL;
3345: END IF;
3346: CLOSE csr_sec_classification;
3340: IF csr_sec_classification%FOUND THEN
3341: l_standard_rate := retro_element_value_rec.value;
3342: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
3343: ELSE
3344: l_standard_rate :=NULL;
3345: END IF;
3346: CLOSE csr_sec_classification;
3347: END IF;
3348: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special'||' '||p_special);
3441:
3442: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_pecentage_rate'||' '||l_pecentage_rate);
3443: END LOOP;
3444:
3445: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3446: l_sum_standard_rate:=NULL;
3447: END IF;
3448:
3449: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
3442: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_pecentage_rate'||' '||l_pecentage_rate);
3443: END LOOP;
3444:
3445: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3446: l_sum_standard_rate:=NULL;
3447: END IF;
3448:
3449: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
3450: l_sum_special_rate:=NULL;
3455: END IF;
3456: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3457: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3458:
3459: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3460: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3461: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3462: OR l_rate is not null) THEN
3463: -- Archive NL CALCULATIONS
3486: ,p_action_information6 =>l_reporting_name
3487: ,p_action_information7 =>l_pecentage_rate
3488: ,p_action_information8 =>p_type
3489: ,p_action_information9 =>l_date --Retro Period
3490: ,p_action_information10 =>l_sum_standard_rate
3491: ,p_action_information11 =>l_sum_special_rate
3492: ,p_action_information12 =>l_sum_payable
3493: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate)
3494: ,p_action_information16 =>l_element_type_id
3495: ,p_action_information17 =>l_run_result_id
3496: );
3497:
3498:
3499: IF p_element_name = 'Retro Employer ZVW Contribution Standard Tax' THEN
3500: g_retro_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);
3501: g_retro_zvw_er_cont_std_ytd := l_rate;
3502: END IF;
3503: IF p_element_name = 'Retro Employer ZVW Contribution Special Tax' THEN
3496: );
3497:
3498:
3499: IF p_element_name = 'Retro Employer ZVW Contribution Standard Tax' THEN
3500: g_retro_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);
3501: g_retro_zvw_er_cont_std_ytd := l_rate;
3502: END IF;
3503: IF p_element_name = 'Retro Employer ZVW Contribution Special Tax' THEN
3504: g_retro_zvw_er_cont_spl_run := FND_NUMBER.canonical_to_number(l_sum_special_rate);
3515:
3516: ELSE
3517: IF p_child_count=0 THEN
3518:
3519: l_sum_standard_rate :='0';
3520: l_sum_special_rate :='0';
3521: l_sum_payable :='0';
3522:
3523: FOR csr_np_rec IN csr_np_children(
3536: ,'Pay Value'
3537: ,p_date_earned) LOOP
3538:
3539:
3540: IF p_standard IS NOT NULL THEN
3541: OPEN csr_sec_classification(element_value_rec.element_type_id
3542: ,p_standard
3543: ,p_date_earned);
3544: FETCH csr_sec_classification INTO l_temp;
3538:
3539:
3540: IF p_standard IS NOT NULL THEN
3541: OPEN csr_sec_classification(element_value_rec.element_type_id
3542: ,p_standard
3543: ,p_date_earned);
3544: FETCH csr_sec_classification INTO l_temp;
3545: IF csr_sec_classification%FOUND THEN
3546: l_standard_rate := element_value_rec.value;
3542: ,p_standard
3543: ,p_date_earned);
3544: FETCH csr_sec_classification INTO l_temp;
3545: IF csr_sec_classification%FOUND THEN
3546: l_standard_rate := element_value_rec.value;
3547: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
3548: ELSE
3549: l_standard_rate :=NULL;
3550: END IF;
3543: ,p_date_earned);
3544: FETCH csr_sec_classification INTO l_temp;
3545: IF csr_sec_classification%FOUND THEN
3546: l_standard_rate := element_value_rec.value;
3547: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
3548: ELSE
3549: l_standard_rate :=NULL;
3550: END IF;
3551: CLOSE csr_sec_classification;
3545: IF csr_sec_classification%FOUND THEN
3546: l_standard_rate := element_value_rec.value;
3547: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
3548: ELSE
3549: l_standard_rate :=NULL;
3550: END IF;
3551: CLOSE csr_sec_classification;
3552: END IF;
3553:
3644: --hr_utility.set_location('Inside archive_payslip_element_info l_date'||l_date,2123);
3645: --
3646: END LOOP;
3647: END LOOP;
3648: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3649: l_sum_standard_rate:=NULL;
3650: END IF;
3651:
3652: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
3645: --
3646: END LOOP;
3647: END LOOP;
3648: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3649: l_sum_standard_rate:=NULL;
3650: END IF;
3651:
3652: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
3653: l_sum_special_rate:=NULL;
3658: END IF;
3659: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3660: --hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3661:
3662: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3663: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3664: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3665: OR l_rate is not null) THEN
3666: -- Archive NL CALCULATIONS
3689: ,p_action_information6 =>l_reporting_name
3690: ,p_action_information7 =>l_pecentage_rate
3691: ,p_action_information8 =>p_type
3692: ,p_action_information9 =>l_date --Retro Period
3693: ,p_action_information10 =>l_sum_standard_rate
3694: ,p_action_information11 =>l_sum_special_rate
3695: ,p_action_information12 =>l_sum_payable
3696: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate));
3697:
3695: ,p_action_information12 =>l_sum_payable
3696: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate));
3697:
3698:
3699: IF p_element_name = 'Employer ZVW Contribution Standard Tax' THEN
3700: g_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);
3701: g_zvw_er_cont_std_ytd := l_rate;
3702: END IF;
3703: IF p_element_name = 'Employer ZVW Contribution Special Tax' THEN
3696: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate));
3697:
3698:
3699: IF p_element_name = 'Employer ZVW Contribution Standard Tax' THEN
3700: g_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);
3701: g_zvw_er_cont_std_ytd := l_rate;
3702: END IF;
3703: IF p_element_name = 'Employer ZVW Contribution Special Tax' THEN
3704: g_zvw_er_cont_spl_run := FND_NUMBER.canonical_to_number(l_sum_special_rate);
3747: ,p_date_earned
3748: ,g_stat_element_table(l_index).main_index
3749: ,g_stat_element_table(l_index).element_type
3750: ,g_stat_element_table(l_index).archive_flag
3751: ,g_stat_element_table(l_index).standard
3752: ,g_stat_element_table(l_index).special
3753: ,g_stat_element_table(l_index).standard2
3754: ,g_stat_element_table(l_index).special2
3755: ,g_stat_element_table(l_index).payable_flag
3749: ,g_stat_element_table(l_index).element_type
3750: ,g_stat_element_table(l_index).archive_flag
3751: ,g_stat_element_table(l_index).standard
3752: ,g_stat_element_table(l_index).special
3753: ,g_stat_element_table(l_index).standard2
3754: ,g_stat_element_table(l_index).special2
3755: ,g_stat_element_table(l_index).payable_flag
3756: ,p_record_count
3757: ,p_master_assign_action_id
3777: PROCEDURE archive_balance_info( p_arch_assign_action_id IN NUMBER
3778: ,p_run_assign_action_id IN NUMBER
3779: ,p_balance_name IN VARCHAR2
3780: ,p_dimension IN VARCHAR2
3781: ,p_standard_bal_name IN VARCHAR2
3782: ,p_special_bal_name IN VARCHAR2
3783: ,p_non_tax_bal_name IN VARCHAR2
3784: ,p_multiply_factor IN NUMBER
3785: ,p_index IN NUMBER
3930: l_si_type pay_action_contexts.context_value%TYPE;
3931: l_si_type_name pay_run_result_values.result_value%TYPE;
3932: l_def_bal_id NUMBER;
3933:
3934: l_standard_rate_run NUMBER;
3935: l_sum_standard_rate_run NUMBER;
3936: l_standard_rate_ytd NUMBER;
3937: l_special_rate_run NUMBER;
3938: l_sum_special_rate_run NUMBER;
3931: l_si_type_name pay_run_result_values.result_value%TYPE;
3932: l_def_bal_id NUMBER;
3933:
3934: l_standard_rate_run NUMBER;
3935: l_sum_standard_rate_run NUMBER;
3936: l_standard_rate_ytd NUMBER;
3937: l_special_rate_run NUMBER;
3938: l_sum_special_rate_run NUMBER;
3939: l_special_rate_ytd NUMBER;
3932: l_def_bal_id NUMBER;
3933:
3934: l_standard_rate_run NUMBER;
3935: l_sum_standard_rate_run NUMBER;
3936: l_standard_rate_ytd NUMBER;
3937: l_special_rate_run NUMBER;
3938: l_sum_special_rate_run NUMBER;
3939: l_special_rate_ytd NUMBER;
3940: l_non_tax_rate_run NUMBER;
3974: -- Loop through pay_action_context table for all SI Type
3975: FOR context_rec IN csr_get_context_id(l_np_child_id,'SOURCE_TEXT')
3976: LOOP
3977: --
3978: l_sum_standard_rate_run:=0;
3979: l_sum_special_rate_run :=0;
3980: l_sum_non_tax_rate_run :=0;
3981: l_sum_payable :=0;
3982: l_sum_year :=0;
3999: LOOP
4000: FETCH csr_np_children into csr_np_rec;
4001: EXIT when csr_np_children%NOTFOUND or csr_np_children%NOTFOUND IS NULL;
4002:
4003: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2120);
4004:
4005: l_si_type := context_rec.value;
4006: l_standard_rate_run := 0;
4007: l_special_rate_run := 0;
4002:
4003: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2120);
4004:
4005: l_si_type := context_rec.value;
4006: l_standard_rate_run := 0;
4007: l_special_rate_run := 0;
4008: l_non_tax_rate_run := 0;
4009:
4010: -- If Standard Balance exist for this balance then retrive them
4006: l_standard_rate_run := 0;
4007: l_special_rate_run := 0;
4008: l_non_tax_rate_run := 0;
4009:
4010: -- If Standard Balance exist for this balance then retrive them
4011: IF p_standard_bal_name IS NOT NULL THEN
4012: --
4013:
4014: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_RUN');
4007: l_special_rate_run := 0;
4008: l_non_tax_rate_run := 0;
4009:
4010: -- If Standard Balance exist for this balance then retrive them
4011: IF p_standard_bal_name IS NOT NULL THEN
4012: --
4013:
4014: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_RUN');
4015: l_standard_rate_run := pay_balance_pkg.get_value(
4010: -- If Standard Balance exist for this balance then retrive them
4011: IF p_standard_bal_name IS NOT NULL THEN
4012: --
4013:
4014: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_RUN');
4015: l_standard_rate_run := pay_balance_pkg.get_value(
4016: l_def_bal_id, csr_np_rec.np_assignment_action_id
4017: ,null,null,context_rec.context_id,context_rec.value
4018: ,null,null);
4011: IF p_standard_bal_name IS NOT NULL THEN
4012: --
4013:
4014: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_RUN');
4015: l_standard_rate_run := pay_balance_pkg.get_value(
4016: l_def_bal_id, csr_np_rec.np_assignment_action_id
4017: ,null,null,context_rec.context_id,context_rec.value
4018: ,null,null);
4019:
4016: l_def_bal_id, csr_np_rec.np_assignment_action_id
4017: ,null,null,context_rec.context_id,context_rec.value
4018: ,null,null);
4019:
4020: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4021:
4022: -- YTD Figure
4023: --
4024: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_YTD');
4020: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4021:
4022: -- YTD Figure
4023: --
4024: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_YTD');
4025: l_standard_rate_ytd := pay_balance_pkg.get_value(
4026: l_def_bal_id, csr_np_rec.np_assignment_action_id
4027: ,null,null,context_rec.context_id,context_rec.value
4028: ,null,null);
4021:
4022: -- YTD Figure
4023: --
4024: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_YTD');
4025: l_standard_rate_ytd := pay_balance_pkg.get_value(
4026: l_def_bal_id, csr_np_rec.np_assignment_action_id
4027: ,null,null,context_rec.context_id,context_rec.value
4028: ,null,null);
4029: l_standard_rate_ytd := NVL(l_standard_rate_ytd,0) * p_multiply_factor;
4025: l_standard_rate_ytd := pay_balance_pkg.get_value(
4026: l_def_bal_id, csr_np_rec.np_assignment_action_id
4027: ,null,null,context_rec.context_id,context_rec.value
4028: ,null,null);
4029: l_standard_rate_ytd := NVL(l_standard_rate_ytd,0) * p_multiply_factor;
4030: --
4031: END IF;
4032:
4033: --hr_utility.set_location('Inside archive_balance_info p_special_bal_name'||p_special_bal_name,2130);
4075: --
4076:
4077: END IF;
4078:
4079: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2150);
4080:
4081: --
4082: IF p_standard_bal_name IS NULL
4083: AND p_special_bal_name IS NULL
4078:
4079: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2150);
4080:
4081: --
4082: IF p_standard_bal_name IS NULL
4083: AND p_special_bal_name IS NULL
4084: AND p_non_tax_bal_name IS NULL THEN
4085: --
4086: l_def_bal_id := get_defined_balance_id (p_balance_name
4102: --
4103: ELSE
4104: --
4105: IF p_payable_flag = 'Y' THEN
4106: l_payable := (nvl(l_standard_rate_run,0) +
4107: nvl(l_special_rate_run,0) +
4108: nvl(l_non_tax_rate_run,0));
4109: END IF;
4110: l_year := (nvl(l_standard_rate_ytd,0) +
4106: l_payable := (nvl(l_standard_rate_run,0) +
4107: nvl(l_special_rate_run,0) +
4108: nvl(l_non_tax_rate_run,0));
4109: END IF;
4110: l_year := (nvl(l_standard_rate_ytd,0) +
4111: nvl(l_special_rate_ytd,0) +
4112: nvl(l_non_tax_rate_ytd,0));
4113: --
4114: END IF;
4112: nvl(l_non_tax_rate_ytd,0));
4113: --
4114: END IF;
4115:
4116: l_sum_standard_rate_run:=l_sum_standard_rate_run + l_standard_rate_run;
4117: l_sum_special_rate_run :=l_sum_special_rate_run + l_special_rate_run;
4118: l_sum_non_tax_rate_run :=l_sum_non_tax_rate_run + l_non_tax_rate_run;
4119: l_sum_payable :=l_sum_payable + l_payable;
4120: l_sum_year :=l_year;
4119: l_sum_payable :=l_sum_payable + l_payable;
4120: l_sum_year :=l_year;
4121:
4122:
4123: IF p_standard_bal_name IS NULL AND l_sum_standard_rate_run=0 THEN
4124: l_sum_standard_rate_run:=NULL;
4125: END IF;
4126:
4127: IF p_special_bal_name IS NULL AND l_sum_special_rate_run=0 THEN
4120: l_sum_year :=l_year;
4121:
4122:
4123: IF p_standard_bal_name IS NULL AND l_sum_standard_rate_run=0 THEN
4124: l_sum_standard_rate_run:=NULL;
4125: END IF;
4126:
4127: IF p_special_bal_name IS NULL AND l_sum_special_rate_run=0 THEN
4128: l_sum_special_rate_run:=NULL;
4131: IF p_payable_flag='N' AND l_sum_payable=0 THEN
4132: l_sum_payable:=NULL;
4133: END IF;
4134: --
4135: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2160);
4136:
4137: -- Retreive SI Type Name from run results
4138: --
4139: p_balance_sit_name:=p_balance_name;
4138: --
4139: p_balance_sit_name:=p_balance_name;
4140:
4141: IF p_balance_name='Employee SI Contribution' THEN
4142: p_balance_sit_name:='Employee SI Contribution Standard Tax';
4143: END IF;
4144:
4145: OPEN csr_get_sit_type_name(p_balance_sit_name
4146: ,csr_np_rec.np_assignment_action_id,p_date_earned,l_si_type);
4146: ,csr_np_rec.np_assignment_action_id,p_date_earned,l_si_type);
4147: FETCH csr_get_sit_type_name INTO l_si_type_name;
4148: CLOSE csr_get_sit_type_name;
4149: --
4150: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2170);
4151: --
4152: -- Get Balance Name to be reported in the Payslip
4153: --
4154: l_balance_name:=p_balance_name;
4164: CLOSE csr_np_children;
4165: END LOOP;--End of Cursor csr_assignment_actions Loop
4166: CLOSE csr_assignment_actions;
4167:
4168: hr_utility.set_location('Inside archive_balance_info1 l_sum_standard_rate_run'||l_sum_standard_rate_run,2229);
4169:
4170: IF l_si_type_name='ZVW' THEN
4171: IF p_balance_name = 'Employer SI Contribution' and l_index < 18700 THEN
4172: l_index := 18700;
4187: l_index := 18950;
4188: END IF;
4189: END IF;
4190:
4191: IF p_archive_flag = 'Y' OR (l_sum_standard_rate_run <> 0
4192: OR l_sum_special_rate_run <> 0
4193: OR l_sum_payable <> 0
4194: OR l_sum_year <> 0 ) THEN
4195: -- Archive NL CALCULATIONS
4214: ,p_action_information6 =>l_balance_name
4215: ,p_action_information7 =>l_si_type_name
4216: ,p_action_information8 =>p_type
4217: ,p_action_information9 =>null
4218: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4219: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4220: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4221: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4222:
4226: END LOOP;--End of Cursor Loop csr_get_context_id
4227: END IF;
4228: --
4229: ELSE -- Non Context Dimension
4230: l_sum_standard_rate_run:=0;
4231: l_sum_special_rate_run :=0;
4232: l_sum_non_tax_rate_run :=0;
4233: l_sum_payable :=0;
4234: l_sum_year :=0;
4231: l_sum_special_rate_run :=0;
4232: l_sum_non_tax_rate_run :=0;
4233: l_sum_payable :=0;
4234: l_sum_year :=0;
4235: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2180);
4236: /* FOR csr_np_rec IN csr_np_children(
4237: p_run_assign_action_id,
4238: p_payroll_action_id,
4239: p_assignment_id,
4251: LOOP
4252: FETCH csr_np_children into csr_np_rec;
4253: EXIT when csr_np_children%NOTFOUND or csr_np_children%NOTFOUND IS NULL;
4254:
4255: l_standard_rate_run := 0;
4256: l_special_rate_run := 0;
4257: l_non_tax_rate_run := 0;
4258:
4259: -- If Standard balance exist for this balance then retrive them
4255: l_standard_rate_run := 0;
4256: l_special_rate_run := 0;
4257: l_non_tax_rate_run := 0;
4258:
4259: -- If Standard balance exist for this balance then retrive them
4260: IF p_standard_bal_name IS NOT NULL THEN
4261: --
4262: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_RUN');
4263: l_standard_rate_run := pay_balance_pkg.get_value(
4256: l_special_rate_run := 0;
4257: l_non_tax_rate_run := 0;
4258:
4259: -- If Standard balance exist for this balance then retrive them
4260: IF p_standard_bal_name IS NOT NULL THEN
4261: --
4262: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_RUN');
4263: l_standard_rate_run := pay_balance_pkg.get_value(
4264: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4258:
4259: -- If Standard balance exist for this balance then retrive them
4260: IF p_standard_bal_name IS NOT NULL THEN
4261: --
4262: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_RUN');
4263: l_standard_rate_run := pay_balance_pkg.get_value(
4264: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4265: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4266: -- YTD Value
4259: -- If Standard balance exist for this balance then retrive them
4260: IF p_standard_bal_name IS NOT NULL THEN
4261: --
4262: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_RUN');
4263: l_standard_rate_run := pay_balance_pkg.get_value(
4264: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4265: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4266: -- YTD Value
4267: --
4261: --
4262: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_RUN');
4263: l_standard_rate_run := pay_balance_pkg.get_value(
4264: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4265: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4266: -- YTD Value
4267: --
4268: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
4269: l_standard_rate_ytd := pay_balance_pkg.get_value(
4264: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4265: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4266: -- YTD Value
4267: --
4268: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
4269: l_standard_rate_ytd := pay_balance_pkg.get_value(
4270: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4271: l_standard_rate_ytd := NVL(l_standard_rate_ytd,0) * p_multiply_factor;
4272: --
4265: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4266: -- YTD Value
4267: --
4268: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
4269: l_standard_rate_ytd := pay_balance_pkg.get_value(
4270: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4271: l_standard_rate_ytd := NVL(l_standard_rate_ytd,0) * p_multiply_factor;
4272: --
4273:
4267: --
4268: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
4269: l_standard_rate_ytd := pay_balance_pkg.get_value(
4270: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4271: l_standard_rate_ytd := NVL(l_standard_rate_ytd,0) * p_multiply_factor;
4272: --
4273:
4274: END IF;
4275:
4307:
4308: END IF;
4309: --
4310:
4311: IF p_standard_bal_name IS NULL
4312: AND p_special_bal_name IS NULL
4313: AND p_non_tax_bal_name IS NULL THEN
4314:
4315: --hr_utility.set_location('Inside archive_balance_info p_balance_name'||p_balance_name,2150);
4355: ELSE
4356:
4357: --
4358: IF p_payable_flag = 'Y' THEN
4359: l_payable := (nvl(l_standard_rate_run,0) +
4360: nvl(l_special_rate_run,0) +
4361: nvl(l_non_tax_rate_run,0));
4362: END IF;
4363:
4360: nvl(l_special_rate_run,0) +
4361: nvl(l_non_tax_rate_run,0));
4362: END IF;
4363:
4364: l_year := (nvl(l_standard_rate_ytd,0) +
4365: nvl(l_special_rate_ytd,0) +
4366: nvl(l_non_tax_rate_ytd,0));
4367: --
4368:
4368:
4369: END IF;
4370: --
4371:
4372: l_sum_standard_rate_run :=l_sum_standard_rate_run + l_standard_rate_run;
4373: l_sum_special_rate_run :=l_sum_special_rate_run + l_special_rate_run;
4374: l_sum_non_tax_rate_run :=l_sum_non_tax_rate_run + l_non_tax_rate_run;
4375: l_sum_payable :=l_sum_payable + l_payable;
4376: l_sum_year :=l_year;
4374: l_sum_non_tax_rate_run :=l_sum_non_tax_rate_run + l_non_tax_rate_run;
4375: l_sum_payable :=l_sum_payable + l_payable;
4376: l_sum_year :=l_year;
4377:
4378: IF p_standard_bal_name IS NULL AND l_sum_standard_rate_run=0 THEN
4379: l_sum_standard_rate_run:=NULL;
4380: END IF;
4381:
4382: IF p_special_bal_name IS NULL AND l_sum_special_rate_run=0 THEN
4375: l_sum_payable :=l_sum_payable + l_payable;
4376: l_sum_year :=l_year;
4377:
4378: IF p_standard_bal_name IS NULL AND l_sum_standard_rate_run=0 THEN
4379: l_sum_standard_rate_run:=NULL;
4380: END IF;
4381:
4382: IF p_special_bal_name IS NULL AND l_sum_special_rate_run=0 THEN
4383: l_sum_special_rate_run:=NULL;
4421: CLOSE csr_np_children;
4422: END LOOP;--End of Cursor Loop csr_assignment_actions
4423: CLOSE csr_assignment_actions;
4424:
4425: IF l_archive_flag = 'Y' OR (l_sum_standard_rate_run <> 0
4426: OR l_sum_special_rate_run <> 0
4427: OR l_sum_payable <> 0
4428: OR l_sum_year <> 0) THEN
4429: -- Archive NL CALCULATIONS
4446: ,p_action_information6 =>l_balance_name
4447: ,p_action_information7 =>NULL
4448: ,p_action_information8 =>p_type
4449: ,p_action_information9 =>null
4450: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4451: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4452: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4453: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4454:
4455: l_index:=l_index+1;
4456:
4457: END IF;
4458:
4459: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2170);
4460: END IF;
4461:
4462: END archive_balance_info;
4463:
4471: PROCEDURE archive_retro_balance_info(p_arch_assign_action_id IN NUMBER
4472: ,p_run_assign_action_id IN NUMBER
4473: ,p_balance_name IN VARCHAR2
4474: ,p_dimension IN VARCHAR2
4475: ,p_standard_bal_name IN VARCHAR2
4476: ,p_special_bal_name IN VARCHAR2
4477: ,p_non_tax_bal_name IN VARCHAR2
4478: ,p_multiply_factor IN NUMBER
4479: ,p_index IN NUMBER
4505: AND prt.effective_end_date
4506: order by np_assignment_action_id;
4507:
4508: --Bug No. 3371141
4509: --Added two additional parameters p_standard_bal_name,p_special_bal_name
4510: CURSOR csr_retro_element_periods(p_assignment_action_id NUMBER
4511: ,p_balance_name VARCHAR2
4512: ,p_standard_bal_name VARCHAR2
4513: ,p_special_bal_name VARCHAR2
4508: --Bug No. 3371141
4509: --Added two additional parameters p_standard_bal_name,p_special_bal_name
4510: CURSOR csr_retro_element_periods(p_assignment_action_id NUMBER
4511: ,p_balance_name VARCHAR2
4512: ,p_standard_bal_name VARCHAR2
4513: ,p_special_bal_name VARCHAR2
4514: ,p_date_earned DATE
4515: ,p_classification_id NUMBER ) IS
4516: SELECT unique prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ RDate -- Bug 5107780
4520: ,pay_element_types_f pet
4521: ,pay_run_results prr
4522: WHERE pbf.balance_type_id = pbt.balance_type_id
4523: AND (pbt.balance_name like p_balance_name||'%'
4524: OR pbt.balance_name like nvl(p_standard_bal_name,p_balance_name)||'%'
4525: OR pbt.balance_name like nvl(p_special_bal_name,p_balance_name)||'%')
4526: AND piv.input_value_id = pbf.input_value_id
4527: AND piv.name ='Pay Value'
4528: AND pet.element_type_id = piv.element_type_id
4678:
4679: l_value VARCHAR2(255);
4680: l_action_info_id NUMBER;
4681: l_ovn NUMBER;
4682: l_standard_rate VARCHAR2(255);
4683: l_special_rate VARCHAR2(255);
4684: l_standard_ptd NUMBER;
4685: l_special_ptd NUMBER;
4686: l_non_rate VARCHAR2(255);
4680: l_action_info_id NUMBER;
4681: l_ovn NUMBER;
4682: l_standard_rate VARCHAR2(255);
4683: l_special_rate VARCHAR2(255);
4684: l_standard_ptd NUMBER;
4685: l_special_ptd NUMBER;
4686: l_non_rate VARCHAR2(255);
4687: l_rate VARCHAR2(255);
4688: l_payable NUMBER;
4687: l_rate VARCHAR2(255);
4688: l_payable NUMBER;
4689: l_def_bal_id NUMBER;
4690: l_index NUMBER;
4691: l_sum_standard_rate VARCHAR2(255);
4692: l_sum_special_rate VARCHAR2(255);
4693: l_sum_non_rate VARCHAR2(255);
4694: l_sum_payable VARCHAR2(255);
4695: l_sum_ptd NUMBER;
4692: l_sum_special_rate VARCHAR2(255);
4693: l_sum_non_rate VARCHAR2(255);
4694: l_sum_payable VARCHAR2(255);
4695: l_sum_ptd NUMBER;
4696: l_standard_year NUMBER;
4697: l_special_year NUMBER;
4698: l_non_year NUMBER;
4699: l_sum_year NUMBER;
4700: l_date VARCHAR2(255);
4751:
4752: --hr_utility.set_location('Inside archive_retro_balance_info l_np_child_id'||l_np_child_id,5020);
4753: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_np_child_id'||' '||l_np_child_id);
4754: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_balance_name'||' '||p_balance_name);
4755: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4756: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
4757: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_date_earned'||' '||p_date_earned);
4758: --Get all the retro periods
4759: --hr_utility.set_location('Inside archive_retro_balance_info p_balance_name'||p_balance_name,5030);
4756: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
4757: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_date_earned'||' '||p_date_earned);
4758: --Get all the retro periods
4759: --hr_utility.set_location('Inside archive_retro_balance_info p_balance_name'||p_balance_name,5030);
4760: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5030);
4761: --hr_utility.set_location('Inside archive_retro_balance_info p_special_bal_name'||p_special_bal_name,5030);
4762: --hr_utility.set_location('Inside archive_retro_balance_info p_date_earned'||p_date_earned,5030);
4763:
4764: OPEN csr_retro_element_periods(l_np_child_id,p_balance_name,p_standard_bal_name
4760: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5030);
4761: --hr_utility.set_location('Inside archive_retro_balance_info p_special_bal_name'||p_special_bal_name,5030);
4762: --hr_utility.set_location('Inside archive_retro_balance_info p_date_earned'||p_date_earned,5030);
4763:
4764: OPEN csr_retro_element_periods(l_np_child_id,p_balance_name,p_standard_bal_name
4765: ,p_special_bal_name,p_date_earned,l_bal_init_class_id);
4766: FETCH csr_retro_element_periods bulk collect into l_element_retro_entries;
4767: CLOSE csr_retro_element_periods;
4768:
4781: FOR i in l_element_retro_entries.first..l_element_retro_entries.last LOOP
4782:
4783: --hr_utility.set_location('Inside archive_retro_balance_info l_element_retro_entries(i)'||l_element_retro_entries(i),5060);
4784: FOR j in l_creator_type.first..l_creator_type.last LOOP
4785: l_sum_standard_rate :='0';
4786: l_sum_special_rate :='0';
4787: l_sum_payable :='0';
4788: l_sum_year :=0;
4789: l_sum_non_rate :='0';
4792:
4793: FOR csr_np_rec IN csr_np_children(p_run_assign_action_id,p_payroll_action_id,
4794: p_assignment_id,p_effective_date)
4795: LOOP
4796: l_standard_rate :='0';
4797: l_special_rate :='0';
4798: l_standard_year :=0;
4799: l_special_year :=0;
4800: l_non_rate :='0';
4794: p_assignment_id,p_effective_date)
4795: LOOP
4796: l_standard_rate :='0';
4797: l_special_rate :='0';
4798: l_standard_year :=0;
4799: l_special_year :=0;
4800: l_non_rate :='0';
4801: l_rate :='0';
4802: l_non_year :=0;
4800: l_non_rate :='0';
4801: l_rate :='0';
4802: l_non_year :=0;
4803:
4804: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4805:
4806: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5070);
4807: l_year_flag := 0;
4808: IF p_standard_bal_name IS NOT NULL THEN
4802: l_non_year :=0;
4803:
4804: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4805:
4806: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5070);
4807: l_year_flag := 0;
4808: IF p_standard_bal_name IS NOT NULL THEN
4809:
4810: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec'||' '||csr_np_rec.np_assignment_action_id);
4804: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4805:
4806: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5070);
4807: l_year_flag := 0;
4808: IF p_standard_bal_name IS NOT NULL THEN
4809:
4810: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec'||' '||csr_np_rec.np_assignment_action_id);
4811: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4812: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_date_earned'||' '||p_date_earned);
4807: l_year_flag := 0;
4808: IF p_standard_bal_name IS NOT NULL THEN
4809:
4810: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec'||' '||csr_np_rec.np_assignment_action_id);
4811: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4812: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_date_earned'||' '||p_date_earned);
4813: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
4814: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'context_rec.value'||' '||context_rec.value);
4815:
4814: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'context_rec.value'||' '||context_rec.value);
4815:
4816: --hr_utility.set_location('Inside archive_retro_balance_info np_assignment_action_id'||csr_np_rec.np_assignment_action_id,5080);
4817:
4818: OPEN csr_retro_values(csr_np_rec.np_assignment_action_id,p_standard_bal_name
4819: ,p_date_earned,l_element_retro_entries(i),context_rec.value,l_creator_type(j),l_bal_init_class_id);
4820: FETCH csr_retro_values INTO l_value,l_si_type_name,l_priority;
4821:
4822: --hr_utility.set_location('Inside archive_retro_balance_info l_value'||l_value,5090);
4828: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
4829:
4830: IF csr_retro_values%FOUND THEN
4831: l_year_flag := 1;
4832: l_standard_rate := l_value;
4833:
4834: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
4835:
4836: l_sum_standard_rate :=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
4830: IF csr_retro_values%FOUND THEN
4831: l_year_flag := 1;
4832: l_standard_rate := l_value;
4833:
4834: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
4835:
4836: l_sum_standard_rate :=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
4837:
4838: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
4832: l_standard_rate := l_value;
4833:
4834: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
4835:
4836: l_sum_standard_rate :=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
4837:
4838: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
4839:
4840: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
4834: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
4835:
4836: l_sum_standard_rate :=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
4837:
4838: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
4839:
4840: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
4841: IF l_si_type_name IS NOT NULL THEN
4842: l_si_type:=l_si_type_name;
4842: l_si_type:=l_si_type_name;
4843: END IF;
4844: END IF;
4845: CLOSE csr_retro_values;
4846: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_YTD');
4847: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
4848: IF l_def_bal_id IS NOT NULL THEN
4849: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
4850: ,csr_np_rec.np_assignment_action_id,null,null,context_rec.context_id,context_rec.value,null,null);
4845: CLOSE csr_retro_values;
4846: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_YTD');
4847: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
4848: IF l_def_bal_id IS NOT NULL THEN
4849: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
4850: ,csr_np_rec.np_assignment_action_id,null,null,context_rec.context_id,context_rec.value,null,null);
4851: END IF;
4852: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
4853:
4848: IF l_def_bal_id IS NOT NULL THEN
4849: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
4850: ,csr_np_rec.np_assignment_action_id,null,null,context_rec.context_id,context_rec.value,null,null);
4851: END IF;
4852: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
4853:
4854: END IF;
4855:
4856: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
4933: END IF;
4934:
4935: --hr_utility.set_location('Inside archive_retro_balance_info p_balance_name'||p_balance_name,5120);
4936:
4937: IF p_standard_bal_name IS NULL
4938: AND p_special_bal_name IS NULL
4939: AND p_non_tax_bal_name IS NULL THEN
4940:
4941: OPEN csr_retro_values(csr_np_rec.np_assignment_action_id,p_balance_name
4970: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_payable_flag'||' '||p_payable_flag);
4971:
4972: IF p_payable_flag='Y' THEN
4973:
4974: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate)
4975: + FND_NUMBER.canonical_to_number(l_sum_special_rate) +FND_NUMBER.canonical_to_number(l_sum_non_rate));
4976:
4977: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
4978: END IF;
4976:
4977: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
4978: END IF;
4979:
4980: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
4981: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_year'||' '||l_special_year);
4982: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_non_year'||' '||l_non_year);
4983: If l_year_flag =1 THEN
4984: l_sum_year:=l_sum_year + l_standard_year + l_special_year + l_non_year;
4980: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
4981: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_year'||' '||l_special_year);
4982: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_non_year'||' '||l_non_year);
4983: If l_year_flag =1 THEN
4984: l_sum_year:=l_sum_year + l_standard_year + l_special_year + l_non_year;
4985: END IF;
4986:
4987: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
4988: END IF;
5024: --hr_utility.set_location('Inside archive_retro_balance_info l_balance_name'||l_balance_name,5150);
5025:
5026:
5027: IF l_balance_name='Retro Net Employee SI Contribution' and
5028: FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5029: l_sum_standard_rate:=NULL;
5030: END IF;
5031:
5032: IF l_balance_name='Retro Net Employee SI Contribution' and
5025:
5026:
5027: IF l_balance_name='Retro Net Employee SI Contribution' and
5028: FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5029: l_sum_standard_rate:=NULL;
5030: END IF;
5031:
5032: IF l_balance_name='Retro Net Employee SI Contribution' and
5033: FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5050: END IF;
5051: --hr_utility.set_location('Inside archive_retro_balance_info l_rate'||l_sum_year,5123);
5052: --hr_utility.set_location('Inside archive_retro_balance_info l_sum_payable'||l_sum_payable,5123);
5053:
5054: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5055: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5056: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5057: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5058:
5056: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5057: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5058:
5059: IF p_archive_flag = 'Y'
5060: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5061: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5062: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5063: OR l_sum_year <> 0) THEN
5064:
5061: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5062: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5063: OR l_sum_year <> 0) THEN
5064:
5065: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5066: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5067: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5068: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5069: -- Archive NL CALCULATIONS
5085: ,p_action_information6 =>l_balance_name
5086: ,p_action_information7 =>l_si_type
5087: ,p_action_information8 =>p_type
5088: ,p_action_information9 =>l_date --Retro Period
5089: ,p_action_information10 =>l_sum_standard_rate
5090: ,p_action_information11 =>l_sum_special_rate
5091: ,p_action_information12 =>l_sum_payable
5092: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
5093: l_index := l_index + 1;
5120: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_balance_name'||' '||p_balance_name);
5121: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_date_earned'||' '||p_date_earned);
5122: --Get all the retro periods
5123: OPEN csr_retro_element_periods(l_np_child_id,p_balance_name
5124: ,p_standard_bal_name,p_special_bal_name,p_date_earned,l_bal_init_class_id);
5125: FETCH csr_retro_element_periods bulk collect into l_element_retro_entries;
5126: CLOSE csr_retro_element_periods;
5127:
5128: --hr_utility.set_location('Inside archive_retro_balance_info non context l_element_retro_entries.count'||l_element_retro_entries.count,6120);
5135: LOOP
5136: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6120);
5137: FOR j in l_creator_type.first..l_creator_type.last
5138: LOOP
5139: l_sum_standard_rate :='0';
5140: l_sum_special_rate :='0';
5141: l_sum_payable :='0';
5142: l_sum_year :=0;
5143: l_sum_ptd :=0;
5147:
5148: FOR csr_np_rec IN csr_np_children(p_run_assign_action_id,
5149: p_payroll_action_id,p_assignment_id,p_effective_date)
5150: LOOP
5151: l_standard_rate :='0';
5152: l_special_rate :='0';
5153: l_standard_year :=0;
5154: l_special_year :=0;
5155: l_non_rate :='0';
5149: p_payroll_action_id,p_assignment_id,p_effective_date)
5150: LOOP
5151: l_standard_rate :='0';
5152: l_special_rate :='0';
5153: l_standard_year :=0;
5154: l_special_year :=0;
5155: l_non_rate :='0';
5156: l_rate :='0';
5157: l_non_year :=0;
5154: l_special_year :=0;
5155: l_non_rate :='0';
5156: l_rate :='0';
5157: l_non_year :=0;
5158: l_standard_ptd :=0;
5159: l_special_ptd :=0;
5160:
5161:
5162: --hr_utility.set_location('Inside archive_retro_balance_info non context csr_np_rec.np_assignment_action_id'||csr_np_rec.np_assignment_action_id,6130);
5160:
5161:
5162: --hr_utility.set_location('Inside archive_retro_balance_info non context csr_np_rec.np_assignment_action_id'||csr_np_rec.np_assignment_action_id,6130);
5163:
5164: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5165:
5166: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6140);
5167:
5168: IF p_standard_bal_name IS NOT NULL THEN
5162: --hr_utility.set_location('Inside archive_retro_balance_info non context csr_np_rec.np_assignment_action_id'||csr_np_rec.np_assignment_action_id,6130);
5163:
5164: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5165:
5166: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6140);
5167:
5168: IF p_standard_bal_name IS NOT NULL THEN
5169:
5170: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec'||' '||csr_np_rec.np_assignment_action_id);
5164: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5165:
5166: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6140);
5167:
5168: IF p_standard_bal_name IS NOT NULL THEN
5169:
5170: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec'||' '||csr_np_rec.np_assignment_action_id);
5171: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5172: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_date_earned'||' '||p_date_earned);
5167:
5168: IF p_standard_bal_name IS NOT NULL THEN
5169:
5170: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec'||' '||csr_np_rec.np_assignment_action_id);
5171: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5172: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_date_earned'||' '||p_date_earned);
5173: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
5174:
5175: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6150);
5171: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5172: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_date_earned'||' '||p_date_earned);
5173: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
5174:
5175: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6150);
5176:
5177: OPEN csr_retro_values_nc(csr_np_rec.np_assignment_action_id,p_standard_bal_name
5178: ,p_date_earned,l_element_retro_entries(i),l_creator_type(j),l_bal_init_class_id);
5179: FETCH csr_retro_values_nc INTO l_value,l_priority;
5173: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
5174:
5175: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6150);
5176:
5177: OPEN csr_retro_values_nc(csr_np_rec.np_assignment_action_id,p_standard_bal_name
5178: ,p_date_earned,l_element_retro_entries(i),l_creator_type(j),l_bal_init_class_id);
5179: FETCH csr_retro_values_nc INTO l_value,l_priority;
5180:
5181: --FND_FILE.PUT_LINE(FND_FILE.LOG,' l_value'||' '||l_value);
5182:
5183: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5184: l_flag:=0;
5185: IF csr_retro_values_nc%FOUND THEN
5186: l_standard_rate := l_value;
5187: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5188: p_multiply_factor);
5189: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
5183: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5184: l_flag:=0;
5185: IF csr_retro_values_nc%FOUND THEN
5186: l_standard_rate := l_value;
5187: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5188: p_multiply_factor);
5189: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
5191: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5185: IF csr_retro_values_nc%FOUND THEN
5186: l_standard_rate := l_value;
5187: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5188: p_multiply_factor);
5189: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
5191: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5192: l_flag:=1;
5193: CLOSE csr_retro_values_nc;
5186: l_standard_rate := l_value;
5187: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5188: p_multiply_factor);
5189: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
5191: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5192: l_flag:=1;
5193: CLOSE csr_retro_values_nc;
5194: ELSIF p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5187: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5188: p_multiply_factor);
5189: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
5191: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5192: l_flag:=1;
5193: CLOSE csr_retro_values_nc;
5194: ELSIF p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5195:
5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
5191: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5192: l_flag:=1;
5193: CLOSE csr_retro_values_nc;
5194: ELSIF p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5195:
5196: IF csr_retro_values_nc%ISOPEN THEN
5197: CLOSE csr_retro_values_nc;
5198: END IF;
5196: IF csr_retro_values_nc%ISOPEN THEN
5197: CLOSE csr_retro_values_nc;
5198: END IF;
5199: OPEN csr_retro_values_nc(csr_np_rec.np_assignment_action_id
5200: ,'Retro Standard Taxable Income Current Quarter',p_date_earned
5201: ,l_element_retro_entries(i),l_creator_type(j),l_bal_init_class_id);
5202: FETCH csr_retro_values_nc INTO l_value,l_priority;
5203:
5204: IF csr_retro_values_nc%FOUND THEN
5201: ,l_element_retro_entries(i),l_creator_type(j),l_bal_init_class_id);
5202: FETCH csr_retro_values_nc INTO l_value,l_priority;
5203:
5204: IF csr_retro_values_nc%FOUND THEN
5205: l_standard_rate := l_value;
5206: l_flag:=1;
5207: END IF;
5208: CLOSE csr_retro_values_nc;
5209: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5205: l_standard_rate := l_value;
5206: l_flag:=1;
5207: END IF;
5208: CLOSE csr_retro_values_nc;
5209: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5210: p_multiply_factor);
5211:
5212: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5213: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) +FND_NUMBER.canonical_to_number( l_standard_rate));
5208: CLOSE csr_retro_values_nc;
5209: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5210: p_multiply_factor);
5211:
5212: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5213: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) +FND_NUMBER.canonical_to_number( l_standard_rate));
5214:
5215: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5216: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5209: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5210: p_multiply_factor);
5211:
5212: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5213: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) +FND_NUMBER.canonical_to_number( l_standard_rate));
5214:
5215: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5216: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5217:
5211:
5212: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5213: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) +FND_NUMBER.canonical_to_number( l_standard_rate));
5214:
5215: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5216: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5217:
5218: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6160);
5219: END IF;
5214:
5215: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5216: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5217:
5218: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6160);
5219: END IF;
5220: --IF l_flag=1 THEN
5221: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
5222: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5217:
5218: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6160);
5219: END IF;
5220: --IF l_flag=1 THEN
5221: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
5222: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5223: IF l_def_bal_id IS NOT NULL THEN
5224: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
5225: ,csr_np_rec.np_assignment_action_id);
5220: --IF l_flag=1 THEN
5221: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
5222: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5223: IF l_def_bal_id IS NOT NULL THEN
5224: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
5225: ,csr_np_rec.np_assignment_action_id);
5226: END IF;
5227: IF /*l_standard_year=0 and*/ p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5228: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter'
5223: IF l_def_bal_id IS NOT NULL THEN
5224: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
5225: ,csr_np_rec.np_assignment_action_id);
5226: END IF;
5227: IF /*l_standard_year=0 and*/ p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5228: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter'
5229: ,'_ASG_YTD');
5230: IF l_def_bal_id IS NOT NULL THEN
5231: l_standard_year := l_standard_year + pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);
5224: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
5225: ,csr_np_rec.np_assignment_action_id);
5226: END IF;
5227: IF /*l_standard_year=0 and*/ p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5228: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter'
5229: ,'_ASG_YTD');
5230: IF l_def_bal_id IS NOT NULL THEN
5231: l_standard_year := l_standard_year + pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);
5232: END IF;
5227: IF /*l_standard_year=0 and*/ p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5228: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter'
5229: ,'_ASG_YTD');
5230: IF l_def_bal_id IS NOT NULL THEN
5231: l_standard_year := l_standard_year + pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);
5232: END IF;
5233: END IF;
5234: l_standard_year := l_standard_year * p_multiply_factor;
5235: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_PTD');
5230: IF l_def_bal_id IS NOT NULL THEN
5231: l_standard_year := l_standard_year + pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);
5232: END IF;
5233: END IF;
5234: l_standard_year := l_standard_year * p_multiply_factor;
5235: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_PTD');
5236: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5237: IF l_def_bal_id IS NOT NULL THEN
5238: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5231: l_standard_year := l_standard_year + pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);
5232: END IF;
5233: END IF;
5234: l_standard_year := l_standard_year * p_multiply_factor;
5235: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_PTD');
5236: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5237: IF l_def_bal_id IS NOT NULL THEN
5238: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5239: ,csr_np_rec.np_assignment_action_id);
5234: l_standard_year := l_standard_year * p_multiply_factor;
5235: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_PTD');
5236: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5237: IF l_def_bal_id IS NOT NULL THEN
5238: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5239: ,csr_np_rec.np_assignment_action_id);
5240: END IF;
5241: IF l_standard_ptd=0 and p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5242: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter','_ASG_PTD');
5237: IF l_def_bal_id IS NOT NULL THEN
5238: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5239: ,csr_np_rec.np_assignment_action_id);
5240: END IF;
5241: IF l_standard_ptd=0 and p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5242: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter','_ASG_PTD');
5243: IF l_def_bal_id IS NOT NULL THEN
5244: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5245: ,csr_np_rec.np_assignment_action_id);
5238: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5239: ,csr_np_rec.np_assignment_action_id);
5240: END IF;
5241: IF l_standard_ptd=0 and p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5242: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter','_ASG_PTD');
5243: IF l_def_bal_id IS NOT NULL THEN
5244: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5245: ,csr_np_rec.np_assignment_action_id);
5246: END IF;
5240: END IF;
5241: IF l_standard_ptd=0 and p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5242: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter','_ASG_PTD');
5243: IF l_def_bal_id IS NOT NULL THEN
5244: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5245: ,csr_np_rec.np_assignment_action_id);
5246: END IF;
5247: END IF;
5248: -- END IF;
5245: ,csr_np_rec.np_assignment_action_id);
5246: END IF;
5247: END IF;
5248: -- END IF;
5249: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
5250:
5251: END IF;
5252: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
5253:
5304:
5305:
5306: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6200);
5307:
5308: IF p_standard_bal_name IS NULL
5309: AND p_special_bal_name IS NULL
5310: AND p_non_tax_bal_name IS NULL THEN
5311:
5312: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6210);
5339:
5340: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_payable_flag'||' '||p_payable_flag);
5341:
5342: IF p_payable_flag='Y' THEN
5343: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_sum_special_rate));
5344: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5345: END IF;
5346:
5347: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
5343: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_sum_special_rate));
5344: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5345: END IF;
5346:
5347: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
5348: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_year'||' '||l_special_year);
5349: IF l_flag = 1 THEN
5350: l_sum_year:=l_standard_year + l_special_year;
5351: END IF;
5346:
5347: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
5348: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_year'||' '||l_special_year);
5349: IF l_flag = 1 THEN
5350: l_sum_year:=l_standard_year + l_special_year;
5351: END IF;
5352: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5353: END IF;
5354:
5371: --hr_utility.set_location('Inside archive_retro_balance_info non context l_balance_name'||l_balance_name,6250);
5372:
5373: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
5374:
5375: l_sum_ptd:=l_standard_ptd + l_special_ptd;
5376:
5377: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'herel_standard_ptd'||' '||l_standard_ptd);
5378: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_ptd'||' '||l_special_ptd);
5379: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_ptd'||' '||l_sum_ptd);
5373: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
5374:
5375: l_sum_ptd:=l_standard_ptd + l_special_ptd;
5376:
5377: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'herel_standard_ptd'||' '||l_standard_ptd);
5378: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_ptd'||' '||l_special_ptd);
5379: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_ptd'||' '||l_sum_ptd);
5380: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
5381: /*Commented codde to fix bug 4035406 - Retro period not displayed for Employee IZA contributions*/
5391:
5392:
5393:
5394:
5395: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5396: l_sum_standard_rate:=NULL;
5397: END IF;
5398:
5399: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5392:
5393:
5394:
5395: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5396: l_sum_standard_rate:=NULL;
5397: END IF;
5398:
5399: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5400: l_sum_special_rate:=NULL;
5403: IF p_payable_flag='N' and FND_NUMBER.canonical_to_number(l_sum_payable) =0 THEN
5404: l_sum_payable:=NULL;
5405: END IF;
5406:
5407: IF p_standard_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5408: l_sum_standard_rate:=NULL;
5409: END IF;
5410:
5411: IF p_special_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5404: l_sum_payable:=NULL;
5405: END IF;
5406:
5407: IF p_standard_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5408: l_sum_standard_rate:=NULL;
5409: END IF;
5410:
5411: IF p_special_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5412: l_sum_special_rate:=NULL;
5413: END IF;
5414:
5415:
5416:
5417: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_standard_rate'||l_sum_standard_rate,6270);
5418: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_year'||l_sum_year,6280);
5419: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5420: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5421: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5415:
5416:
5417: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_standard_rate'||l_sum_standard_rate,6270);
5418: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_year'||l_sum_year,6280);
5419: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5420: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5421: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5422: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5423:
5422: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5423:
5424: /* for 4253974 */
5425: IF ( p_archive_flag = 'Y' and l_date is not null and
5426: (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0 OR
5427: FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0 OR
5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR
5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))
5427: FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0 OR
5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR
5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))
5431: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5434: OR l_sum_year <> 0) THEN
5435:
5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5434: OR l_sum_year <> 0) THEN
5435:
5436: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5437: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5438: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5439: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5440: -- Archive NL CALCULATIONS
5456: ,p_action_information6 =>l_balance_name
5457: ,p_action_information7 =>l_si_type
5458: ,p_action_information8 =>p_type
5459: ,p_action_information9 =>l_date --Retro Period
5460: ,p_action_information10 =>l_sum_standard_rate
5461: ,p_action_information11 =>l_sum_special_rate
5462: ,p_action_information12 =>l_sum_payable
5463: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
5464: l_index := l_index + 1;
5507: archive_balance_info(p_arch_assign_action_id
5508: ,p_run_assign_action_id
5509: ,'Foreigner Rule SI Income'
5510: ,'_ASG_YTD'
5511: ,'Foreigner Rule SI Income Standard Adjustment'
5512: ,'Foreigner Rule SI Income Special Adjustment'
5513: ,NULL
5514: ,1
5515: ,14800
5529: archive_balance_info(p_arch_assign_action_id
5530: ,p_run_assign_action_id
5531: ,'SI Income'
5532: ,'_ASG_YTD'
5533: ,'SI Income Standard Tax'
5534: ,'SI Income Special Tax'
5535: ,NULL
5536: ,1
5537: ,15000
5552: /*archive_balance_info(p_arch_assign_action_id
5553: ,p_run_assign_action_id
5554: ,'IZA Income'
5555: ,'_ASG_YTD'
5556: ,'IZA Income Standard Tax'
5557: ,'IZA Income Special Tax'
5558: ,'IZA Income Non Taxable'
5559: ,1
5560: ,15600
5574: archive_balance_info(p_arch_assign_action_id
5575: ,p_run_assign_action_id
5576: ,'Employer SI Contribution'
5577: ,'_ASG_SIT_YTD'
5578: ,'Employer SI Contribution Standard Tax'
5579: ,'Employer SI Contribution Special Tax'
5580: ,NULL
5581: ,1
5582: ,16000
5596: archive_balance_info(p_arch_assign_action_id
5597: ,p_run_assign_action_id
5598: ,'Employee SI Contribution'
5599: ,'_ASG_SIT_YTD'
5600: ,'Employee SI Contribution Standard Tax'
5601: ,'Employee SI Contribution Special Tax'
5602: ,'Employee SI Contribution Non Taxable'
5603: ,1
5604: ,17000
5640: archive_balance_info(p_arch_assign_action_id
5641: ,p_run_assign_action_id
5642: ,'Foreigner Rule ZVW Income'
5643: ,'_ASG_YTD'
5644: ,'Foreigner Rule ZVW Income Standard Adjustment'
5645: ,'Foreigner Rule ZVW Income Special Adjustment'
5646: ,NULL
5647: ,1
5648: ,18550
5661: archive_balance_info(p_arch_assign_action_id
5662: ,p_run_assign_action_id
5663: ,'ZVW Income'
5664: ,'_ASG_YTD'
5665: ,'ZVW Income Standard Tax'
5666: ,'ZVW Income Special Tax'
5667: ,NULL
5668: ,1
5669: ,18600
5745: ,p_effective_date);*/
5746:
5747: --
5748: --
5749: -- Archive Foreigner Rule Standard/Special Balances
5750: --
5751: archive_balance_info(p_arch_assign_action_id
5752: ,p_run_assign_action_id
5753: ,'Foreigner Rule (Taxable)'
5751: archive_balance_info(p_arch_assign_action_id
5752: ,p_run_assign_action_id
5753: ,'Foreigner Rule (Taxable)'
5754: ,'_ASG_YTD'
5755: ,'Foreigner Rule Standard Tax Adjustment'
5756: ,'Foreigner Rule Special Tax Adjustment'
5757: ,NULL
5758: ,1
5759: ,21000
5773: archive_balance_info(p_arch_assign_action_id
5774: ,p_run_assign_action_id
5775: ,'Taxable Income'
5776: ,'_ASG_YTD'
5777: ,'Standard Taxable Income'
5778: ,'Special Taxable Income'
5779: ,NULL
5780: ,1
5781: ,22000
5794: archive_retro_balance_info(p_arch_assign_action_id
5795: ,p_run_assign_action_id
5796: ,'Retro Foreigner Rule SI Income'
5797: ,'_ASG_YTD'
5798: ,'Retro Foreigner Rule SI Income Standard Adjustment'
5799: ,'Retro Foreigner Rule SI Income Special Adjustment'
5800: ,NULL
5801: ,1
5802: ,14900
5815: archive_retro_balance_info(p_arch_assign_action_id
5816: ,p_run_assign_action_id
5817: ,'Retro SI Income'
5818: ,'_ASG_YTD'
5819: ,'Retro SI Income Standard Tax'
5820: ,'Retro SI Income Special Tax'
5821: ,NULL
5822: ,1
5823: ,15500
5835: /*archive_retro_balance_info(p_arch_assign_action_id
5836: ,p_run_assign_action_id
5837: ,'Retro IZA Income'
5838: ,'_ASG_YTD'
5839: ,'Retro IZA Income Standard Tax'
5840: ,'Retro IZA Income Special Tax'
5841: ,'Retro IZA Income Non Taxable'
5842: ,1
5843: ,15700
5856: archive_retro_balance_info(p_arch_assign_action_id
5857: ,p_run_assign_action_id
5858: ,'Retro Employer SI Contribution'
5859: ,'_ASG_SIT_YTD'
5860: ,'Retro Employer SI Contribution Standard Tax'
5861: ,'Retro Employer SI Contribution Special Tax'
5862: ,NULL
5863: ,1
5864: ,16500
5877: archive_retro_balance_info(p_arch_assign_action_id
5878: ,p_run_assign_action_id
5879: ,'Retro Employee SI Contribution'
5880: ,'_ASG_SIT_YTD'
5881: ,'Retro Employee SI Contribution Standard Tax'
5882: ,'Retro Employee SI Contribution Special Tax'
5883: ,'Retro Employee SI Contribution Non Taxable'
5884: ,1
5885: ,17500
5918: archive_retro_balance_info(p_arch_assign_action_id
5919: ,p_run_assign_action_id
5920: ,'Retro ZVW Income'
5921: ,'_ASG_YTD'
5922: ,'Retro ZVW Income Standard Tax'
5923: ,'Retro ZVW Income Special Tax'
5924: ,NULL
5925: ,1
5926: ,18650
5994: ,p_payroll_action_id
5995: ,p_assignment_id
5996: ,p_effective_date);*/
5997:
5998: -- Archive Retro Foreigner Rule Standard/Special Balances
5999: --
6000: archive_retro_balance_info(p_arch_assign_action_id
6001: ,p_run_assign_action_id
6002: ,'Retro Foreigner Rule (Taxable)'
6000: archive_retro_balance_info(p_arch_assign_action_id
6001: ,p_run_assign_action_id
6002: ,'Retro Foreigner Rule (Taxable)'
6003: ,'_ASG_YTD'
6004: ,'Retro Foreigner Rule Standard Tax Adjustment'
6005: ,'Retro Foreigner Rule Special Tax Adjustment'
6006: ,NULL
6007: ,1
6008: ,21500
6021: archive_retro_balance_info(p_arch_assign_action_id
6022: ,p_run_assign_action_id
6023: ,'Retro Taxable Income'
6024: ,'_ASG_YTD'
6025: ,'Retro Standard Taxable Income'
6026: ,'Retro Special Taxable Income'
6027: ,NULL
6028: ,1
6029: ,22500
6115: AND p_effective_date BETWEEN prt.effective_start_date
6116: AND prt.effective_end_date
6117: UNION
6118: SELECT paa.assignment_action_id child_assignment_action_id,
6119: 'NP' run_type --Standard Run, Process Separate Run
6120: FROM pay_assignment_actions paa
6121: WHERE paa.payroll_action_id = p_payroll_action_id
6122: AND paa.assignment_id = p_assignment_id
6123: AND paa.action_sequence = (