eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PAY_BALANCE_PKG

Line 970: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

966: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);
967: OPEN csr_extra_assignment(l_assignment_id);
968: FETCH csr_extra_assignment INTO l_work_type;
969: CLOSE csr_extra_assignment;
970: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
971: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
972:
973: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
974: fnd_file.put_line(fnd_file.LOG,'steering code 001');

Line 971: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);

967: OPEN csr_extra_assignment(l_assignment_id);
968: FETCH csr_extra_assignment INTO l_work_type;
969: CLOSE csr_extra_assignment;
970: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
971: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
972:
973: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
974: fnd_file.put_line(fnd_file.LOG,'steering code 001');
975: l_balance_type_id:=csr_balance.balance_type_id;

Line 981: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

977: OPEN csr_defined_balances(l_balance_type_id);
978: FETCH csr_defined_balances INTO l_defined_balance_id;
979: CLOSE csr_defined_balances;
980: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);
981: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
982: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
983: P_VIRTUAL_DATE=>g_end_date),0);
984: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);
985: l_001_steering_code:=l_001_steering_code+l_value;

Line 994: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

990: l_balance_type_id:=csr_balance.balance_type_id;
991: OPEN csr_defined_balances(l_balance_type_id);
992: FETCH csr_defined_balances INTO l_defined_balance_id;
993: CLOSE csr_defined_balances;
994: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
995: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
996: P_VIRTUAL_DATE=>g_end_date),0);
997: l_002_steering_code:=l_002_steering_code+l_value;
998: END LOOP;

Line 1005: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1001: l_balance_type_id:=csr_balance.balance_type_id;
1002: OPEN csr_defined_balances(l_balance_type_id);
1003: FETCH csr_defined_balances INTO l_defined_balance_id;
1004: CLOSE csr_defined_balances;
1005: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1006: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1007: P_VIRTUAL_DATE=>g_end_date),0);
1008: l_003_steering_code:=l_003_steering_code+l_value;
1009: END LOOP;

Line 1016: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1012: l_balance_type_id:=csr_balance.balance_type_id;
1013: OPEN csr_defined_balances(l_balance_type_id);
1014: FETCH csr_defined_balances INTO l_defined_balance_id;
1015: CLOSE csr_defined_balances;
1016: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1017: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1018: P_VIRTUAL_DATE=>g_end_date),0);
1019: l_004_steering_code:=l_004_steering_code+l_value;
1020: END LOOP;

Line 1027: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1023: l_balance_type_id:=csr_balance.balance_type_id;
1024: OPEN csr_defined_balances(l_balance_type_id);
1025: FETCH csr_defined_balances INTO l_defined_balance_id;
1026: CLOSE csr_defined_balances;
1027: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1028: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1029: P_VIRTUAL_DATE=>g_end_date),0);
1030: l_051_steering_code:=l_051_steering_code+l_value;
1031: END LOOP;

Line 1038: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1034: l_balance_type_id:=csr_balance.balance_type_id;
1035: OPEN csr_defined_balances(l_balance_type_id);
1036: FETCH csr_defined_balances INTO l_defined_balance_id;
1037: CLOSE csr_defined_balances;
1038: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1039: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1040: P_VIRTUAL_DATE=>g_end_date),0);
1041: l_052_steering_code:=l_052_steering_code+l_value;
1042: END LOOP;

Line 1049: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1045: l_balance_type_id:=csr_balance.balance_type_id;
1046: OPEN csr_defined_balances(l_balance_type_id);
1047: FETCH csr_defined_balances INTO l_defined_balance_id;
1048: CLOSE csr_defined_balances;
1049: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1050: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1051: P_VIRTUAL_DATE=>g_end_date),0);
1052: l_053_steering_code:=l_053_steering_code+l_value;
1053: END LOOP;

Line 1060: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1056: l_balance_type_id:=csr_balance.balance_type_id;
1057: OPEN csr_defined_balances(l_balance_type_id);
1058: FETCH csr_defined_balances INTO l_defined_balance_id;
1059: CLOSE csr_defined_balances;
1060: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1061: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1062: P_VIRTUAL_DATE=>g_end_date),0);
1063: l_054_steering_code:=l_054_steering_code+l_value;
1064: END LOOP;

Line 1071: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1067: l_balance_type_id:=csr_balance.balance_type_id;
1068: OPEN csr_defined_balances(l_balance_type_id);
1069: FETCH csr_defined_balances INTO l_defined_balance_id;
1070: CLOSE csr_defined_balances;
1071: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1072: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1073: P_VIRTUAL_DATE=>g_end_date),0);
1074: l_055_steering_code:=l_055_steering_code+l_value;
1075: END LOOP;

Line 1082: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1078: l_balance_type_id:=csr_balance.balance_type_id;
1079: OPEN csr_defined_balances(l_balance_type_id);
1080: FETCH csr_defined_balances INTO l_defined_balance_id;
1081: CLOSE csr_defined_balances;
1082: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1083: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1084: P_VIRTUAL_DATE=>g_end_date),0);
1085: l_056_steering_code:=l_056_steering_code+l_value;
1086: END LOOP;

Line 1093: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1089: l_balance_type_id:=csr_balance.balance_type_id;
1090: OPEN csr_defined_balances(l_balance_type_id);
1091: FETCH csr_defined_balances INTO l_defined_balance_id;
1092: CLOSE csr_defined_balances;
1093: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1094: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1095: P_VIRTUAL_DATE=>g_end_date),0);
1096: l_058_steering_code:=l_058_steering_code+l_value;
1097: END LOOP;

Line 1104: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1100: l_balance_type_id:=csr_balance.balance_type_id;
1101: OPEN csr_defined_balances(l_balance_type_id);
1102: FETCH csr_defined_balances INTO l_defined_balance_id;
1103: CLOSE csr_defined_balances;
1104: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1105: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1106: P_VIRTUAL_DATE=>g_end_date),0);
1107: l_600_steering_code:=l_600_steering_code+l_value;
1108: END LOOP;

Line 1115: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1111: l_balance_type_id:=csr_balance.balance_type_id;
1112: OPEN csr_defined_balances(l_balance_type_id);
1113: FETCH csr_defined_balances INTO l_defined_balance_id;
1114: CLOSE csr_defined_balances;
1115: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1116: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1117: P_VIRTUAL_DATE=>g_end_date),0);
1118: l_601_steering_code:=l_601_steering_code+l_value;
1119: END LOOP;

Line 1126: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1122: l_balance_type_id:=csr_balance.balance_type_id;
1123: OPEN csr_defined_balances(l_balance_type_id);
1124: FETCH csr_defined_balances INTO l_defined_balance_id;
1125: CLOSE csr_defined_balances;
1126: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1127: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1128: P_VIRTUAL_DATE=>g_end_date),0);
1129: l_810_steering_code:=l_810_steering_code+l_value;
1130: END LOOP;

Line 1137: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1133: l_balance_type_id:=csr_balance.balance_type_id;
1134: OPEN csr_defined_balances(l_balance_type_id);
1135: FETCH csr_defined_balances INTO l_defined_balance_id;
1136: CLOSE csr_defined_balances;
1137: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1138: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1139: P_VIRTUAL_DATE=>g_end_date),0);
1140: l_800_steering_code:=l_800_steering_code+l_value;
1141: END LOOP;

Line 1148: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1144: l_balance_type_id:=csr_balance.balance_type_id;
1145: OPEN csr_defined_balances(l_balance_type_id);
1146: FETCH csr_defined_balances INTO l_defined_balance_id;
1147: CLOSE csr_defined_balances;
1148: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1149: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1150: P_VIRTUAL_DATE=>g_end_date),0);
1151: l_801_steering_code:=l_801_steering_code+l_value;
1152: END LOOP;

Line 1159: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1155: l_balance_type_id:=csr_balance.balance_type_id;
1156: OPEN csr_defined_balances(l_balance_type_id);
1157: FETCH csr_defined_balances INTO l_defined_balance_id;
1158: CLOSE csr_defined_balances;
1159: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1160: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1161: P_VIRTUAL_DATE=>g_end_date),0);
1162: l_802_steering_code:=l_802_steering_code+l_value;
1163: END LOOP;

Line 1170: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1166: l_balance_type_id:=csr_balance.balance_type_id;
1167: OPEN csr_defined_balances(l_balance_type_id);
1168: FETCH csr_defined_balances INTO l_defined_balance_id;
1169: CLOSE csr_defined_balances;
1170: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1171: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1172: P_VIRTUAL_DATE=>g_end_date),0);
1173: l_803_steering_code:=l_803_steering_code+l_value;
1174: END LOOP;

Line 1181: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1177: l_balance_type_id:=csr_balance.balance_type_id;
1178: OPEN csr_defined_balances(l_balance_type_id);
1179: FETCH csr_defined_balances INTO l_defined_balance_id;
1180: CLOSE csr_defined_balances;
1181: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1182: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1183: P_VIRTUAL_DATE=>g_end_date),0);
1184: l_804_steering_code:=l_804_steering_code+l_value;
1185: END LOOP;

Line 1192: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1188: l_balance_type_id:=csr_balance.balance_type_id;
1189: OPEN csr_defined_balances(l_balance_type_id);
1190: FETCH csr_defined_balances INTO l_defined_balance_id;
1191: CLOSE csr_defined_balances;
1192: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1193: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1194: P_VIRTUAL_DATE=>g_end_date),0);
1195: l_805_steering_code:=l_805_steering_code+l_value;
1196: END LOOP;

Line 1203: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1199: l_balance_type_id:=csr_balance.balance_type_id;
1200: OPEN csr_defined_balances(l_balance_type_id);
1201: FETCH csr_defined_balances INTO l_defined_balance_id;
1202: CLOSE csr_defined_balances;
1203: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1204: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1205: P_VIRTUAL_DATE=>g_end_date),0);
1206: l_806_steering_code:=l_806_steering_code+l_value;
1207: END LOOP;

Line 1214: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1210: l_balance_type_id:=csr_balance.balance_type_id;
1211: OPEN csr_defined_balances(l_balance_type_id);
1212: FETCH csr_defined_balances INTO l_defined_balance_id;
1213: CLOSE csr_defined_balances;
1214: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1215: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1216: P_VIRTUAL_DATE=>g_end_date),0);
1217: l_808_steering_code:=l_808_steering_code+l_value;
1218: END LOOP;

Line 1348: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

1344: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);
1345: OPEN csr_extra_assignment(l_assignment_id);
1346: FETCH csr_extra_assignment INTO l_work_type;
1347: CLOSE csr_extra_assignment;
1348: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1349: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1350:
1351: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
1352: fnd_file.put_line(fnd_file.LOG,'steering code 001');

Line 1349: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);

1345: OPEN csr_extra_assignment(l_assignment_id);
1346: FETCH csr_extra_assignment INTO l_work_type;
1347: CLOSE csr_extra_assignment;
1348: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1349: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1350:
1351: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
1352: fnd_file.put_line(fnd_file.LOG,'steering code 001');
1353: l_balance_type_id:=csr_balance.balance_type_id;

Line 1359: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1355: OPEN csr_defined_balances(l_balance_type_id);
1356: FETCH csr_defined_balances INTO l_defined_balance_id;
1357: CLOSE csr_defined_balances;
1358: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);
1359: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1360: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1361: P_VIRTUAL_DATE=>g_end_date),0);
1362: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);
1363: l_001_steering_code:=l_001_steering_code+l_value;

Line 1372: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1368: l_balance_type_id:=csr_balance.balance_type_id;
1369: OPEN csr_defined_balances(l_balance_type_id);
1370: FETCH csr_defined_balances INTO l_defined_balance_id;
1371: CLOSE csr_defined_balances;
1372: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1373: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1374: P_VIRTUAL_DATE=>g_end_date),0);
1375: l_002_steering_code:=l_002_steering_code+l_value;
1376: END LOOP;

Line 1383: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1379: l_balance_type_id:=csr_balance.balance_type_id;
1380: OPEN csr_defined_balances(l_balance_type_id);
1381: FETCH csr_defined_balances INTO l_defined_balance_id;
1382: CLOSE csr_defined_balances;
1383: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1384: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1385: P_VIRTUAL_DATE=>g_end_date),0);
1386: l_003_steering_code:=l_003_steering_code+l_value;
1387: END LOOP;

Line 1394: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1390: l_balance_type_id:=csr_balance.balance_type_id;
1391: OPEN csr_defined_balances(l_balance_type_id);
1392: FETCH csr_defined_balances INTO l_defined_balance_id;
1393: CLOSE csr_defined_balances;
1394: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1395: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1396: P_VIRTUAL_DATE=>g_end_date),0);
1397: l_004_steering_code:=l_004_steering_code+l_value;
1398: END LOOP;

Line 1405: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1401: l_balance_type_id:=csr_balance.balance_type_id;
1402: OPEN csr_defined_balances(l_balance_type_id);
1403: FETCH csr_defined_balances INTO l_defined_balance_id;
1404: CLOSE csr_defined_balances;
1405: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1406: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1407: P_VIRTUAL_DATE=>g_end_date),0);
1408: l_051_steering_code:=l_051_steering_code+l_value;
1409: END LOOP;

Line 1416: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1412: l_balance_type_id:=csr_balance.balance_type_id;
1413: OPEN csr_defined_balances(l_balance_type_id);
1414: FETCH csr_defined_balances INTO l_defined_balance_id;
1415: CLOSE csr_defined_balances;
1416: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1417: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1418: P_VIRTUAL_DATE=>g_end_date),0);
1419: l_052_steering_code:=l_052_steering_code+l_value;
1420: END LOOP;

Line 1427: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1423: l_balance_type_id:=csr_balance.balance_type_id;
1424: OPEN csr_defined_balances(l_balance_type_id);
1425: FETCH csr_defined_balances INTO l_defined_balance_id;
1426: CLOSE csr_defined_balances;
1427: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1428: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1429: P_VIRTUAL_DATE=>g_end_date),0);
1430: l_053_steering_code:=l_053_steering_code+l_value;
1431: END LOOP;

Line 1438: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1434: l_balance_type_id:=csr_balance.balance_type_id;
1435: OPEN csr_defined_balances(l_balance_type_id);
1436: FETCH csr_defined_balances INTO l_defined_balance_id;
1437: CLOSE csr_defined_balances;
1438: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1439: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1440: P_VIRTUAL_DATE=>g_end_date),0);
1441: l_054_steering_code:=l_054_steering_code+l_value;
1442: END LOOP;

Line 1449: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1445: l_balance_type_id:=csr_balance.balance_type_id;
1446: OPEN csr_defined_balances(l_balance_type_id);
1447: FETCH csr_defined_balances INTO l_defined_balance_id;
1448: CLOSE csr_defined_balances;
1449: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1450: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1451: P_VIRTUAL_DATE=>g_end_date),0);
1452: l_055_steering_code:=l_055_steering_code+l_value;
1453: END LOOP;

Line 1460: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1456: l_balance_type_id:=csr_balance.balance_type_id;
1457: OPEN csr_defined_balances(l_balance_type_id);
1458: FETCH csr_defined_balances INTO l_defined_balance_id;
1459: CLOSE csr_defined_balances;
1460: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1461: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1462: P_VIRTUAL_DATE=>g_end_date),0);
1463: l_056_steering_code:=l_056_steering_code+l_value;
1464: END LOOP;

Line 1471: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1467: l_balance_type_id:=csr_balance.balance_type_id;
1468: OPEN csr_defined_balances(l_balance_type_id);
1469: FETCH csr_defined_balances INTO l_defined_balance_id;
1470: CLOSE csr_defined_balances;
1471: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1472: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1473: P_VIRTUAL_DATE=>g_end_date),0);
1474: l_058_steering_code:=l_058_steering_code+l_value;
1475: END LOOP;

Line 1482: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1478: l_balance_type_id:=csr_balance.balance_type_id;
1479: OPEN csr_defined_balances(l_balance_type_id);
1480: FETCH csr_defined_balances INTO l_defined_balance_id;
1481: CLOSE csr_defined_balances;
1482: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1483: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1484: P_VIRTUAL_DATE=>g_end_date),0);
1485: l_600_steering_code:=l_600_steering_code+l_value;
1486: END LOOP;

Line 1493: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1489: l_balance_type_id:=csr_balance.balance_type_id;
1490: OPEN csr_defined_balances(l_balance_type_id);
1491: FETCH csr_defined_balances INTO l_defined_balance_id;
1492: CLOSE csr_defined_balances;
1493: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1494: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1495: P_VIRTUAL_DATE=>g_end_date),0);
1496: l_601_steering_code:=l_601_steering_code+l_value;
1497: END LOOP;

Line 1504: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1500: l_balance_type_id:=csr_balance.balance_type_id;
1501: OPEN csr_defined_balances(l_balance_type_id);
1502: FETCH csr_defined_balances INTO l_defined_balance_id;
1503: CLOSE csr_defined_balances;
1504: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1505: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1506: P_VIRTUAL_DATE=>g_end_date),0);
1507: l_810_steering_code:=l_810_steering_code+l_value;
1508: END LOOP;

Line 1515: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1511: l_balance_type_id:=csr_balance.balance_type_id;
1512: OPEN csr_defined_balances(l_balance_type_id);
1513: FETCH csr_defined_balances INTO l_defined_balance_id;
1514: CLOSE csr_defined_balances;
1515: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1516: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1517: P_VIRTUAL_DATE=>g_end_date),0);
1518: l_800_steering_code:=l_800_steering_code+l_value;
1519: END LOOP;

Line 1526: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1522: l_balance_type_id:=csr_balance.balance_type_id;
1523: OPEN csr_defined_balances(l_balance_type_id);
1524: FETCH csr_defined_balances INTO l_defined_balance_id;
1525: CLOSE csr_defined_balances;
1526: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1527: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1528: P_VIRTUAL_DATE=>g_end_date),0);
1529: l_801_steering_code:=l_801_steering_code+l_value;
1530: END LOOP;

Line 1537: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1533: l_balance_type_id:=csr_balance.balance_type_id;
1534: OPEN csr_defined_balances(l_balance_type_id);
1535: FETCH csr_defined_balances INTO l_defined_balance_id;
1536: CLOSE csr_defined_balances;
1537: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1538: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1539: P_VIRTUAL_DATE=>g_end_date),0);
1540: l_802_steering_code:=l_802_steering_code+l_value;
1541: END LOOP;

Line 1548: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1544: l_balance_type_id:=csr_balance.balance_type_id;
1545: OPEN csr_defined_balances(l_balance_type_id);
1546: FETCH csr_defined_balances INTO l_defined_balance_id;
1547: CLOSE csr_defined_balances;
1548: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1549: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1550: P_VIRTUAL_DATE=>g_end_date),0);
1551: l_803_steering_code:=l_803_steering_code+l_value;
1552: END LOOP;

Line 1559: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1555: l_balance_type_id:=csr_balance.balance_type_id;
1556: OPEN csr_defined_balances(l_balance_type_id);
1557: FETCH csr_defined_balances INTO l_defined_balance_id;
1558: CLOSE csr_defined_balances;
1559: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1560: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1561: P_VIRTUAL_DATE=>g_end_date),0);
1562: l_804_steering_code:=l_804_steering_code+l_value;
1563: END LOOP;

Line 1570: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1566: l_balance_type_id:=csr_balance.balance_type_id;
1567: OPEN csr_defined_balances(l_balance_type_id);
1568: FETCH csr_defined_balances INTO l_defined_balance_id;
1569: CLOSE csr_defined_balances;
1570: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1571: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1572: P_VIRTUAL_DATE=>g_end_date),0);
1573: l_805_steering_code:=l_805_steering_code+l_value;
1574: END LOOP;

Line 1581: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1577: l_balance_type_id:=csr_balance.balance_type_id;
1578: OPEN csr_defined_balances(l_balance_type_id);
1579: FETCH csr_defined_balances INTO l_defined_balance_id;
1580: CLOSE csr_defined_balances;
1581: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1582: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1583: P_VIRTUAL_DATE=>g_end_date),0);
1584: l_806_steering_code:=l_806_steering_code+l_value;
1585: END LOOP;

Line 1592: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,

1588: l_balance_type_id:=csr_balance.balance_type_id;
1589: OPEN csr_defined_balances(l_balance_type_id);
1590: FETCH csr_defined_balances INTO l_defined_balance_id;
1591: CLOSE csr_defined_balances;
1592: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1593: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1594: P_VIRTUAL_DATE=>g_end_date),0);
1595: l_808_steering_code:=l_808_steering_code+l_value;
1596: END LOOP;

Line 1837: (pay_balance_pkg.get_value

1833: CLOSE csr_def_bal_id;
1834:
1835: l_return_balance_value :=
1836: TO_CHAR
1837: (pay_balance_pkg.get_value
1838: (p_defined_balance_id => l_defined_balance_id
1839: , p_assignment_id => p_in_assignment_id
1840: , p_virtual_date => p_in_virtual_date
1841: )