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 986: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

982:
983: OPEN csr_extra_assignment(l_assignment_id);
984: FETCH csr_extra_assignment INTO l_work_type;
985: CLOSE csr_extra_assignment;
986: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
987: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
988:
989: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
990:

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

983: OPEN csr_extra_assignment(l_assignment_id);
984: FETCH csr_extra_assignment INTO l_work_type;
985: CLOSE csr_extra_assignment;
986: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
987: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
988:
989: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
990:
991: l_balance_type_id:=csr_balance.balance_type_id;

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

993: OPEN csr_defined_balances(l_balance_type_id);
994: FETCH csr_defined_balances INTO l_defined_balance_id;
995: CLOSE csr_defined_balances;
996:
997: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
998: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
999: P_VIRTUAL_DATE=>g_end_date),0);
1000:
1001: l_001_steering_code:=l_001_steering_code+l_value;

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

1006: l_balance_type_id:=csr_balance.balance_type_id;
1007: OPEN csr_defined_balances(l_balance_type_id);
1008: FETCH csr_defined_balances INTO l_defined_balance_id;
1009: CLOSE csr_defined_balances;
1010: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1011: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1012: P_VIRTUAL_DATE=>g_end_date),0);
1013: l_002_steering_code:=l_002_steering_code+l_value;
1014: END LOOP;

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

1017: l_balance_type_id:=csr_balance.balance_type_id;
1018: OPEN csr_defined_balances(l_balance_type_id);
1019: FETCH csr_defined_balances INTO l_defined_balance_id;
1020: CLOSE csr_defined_balances;
1021: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1022: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1023: P_VIRTUAL_DATE=>g_end_date),0);
1024: l_003_steering_code:=l_003_steering_code+l_value;
1025: END LOOP;

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

1028: l_balance_type_id:=csr_balance.balance_type_id;
1029: OPEN csr_defined_balances(l_balance_type_id);
1030: FETCH csr_defined_balances INTO l_defined_balance_id;
1031: CLOSE csr_defined_balances;
1032: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1033: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1034: P_VIRTUAL_DATE=>g_end_date),0);
1035: l_004_steering_code:=l_004_steering_code+l_value;
1036: END LOOP;

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

1039: l_balance_type_id:=csr_balance.balance_type_id;
1040: OPEN csr_defined_balances(l_balance_type_id);
1041: FETCH csr_defined_balances INTO l_defined_balance_id;
1042: CLOSE csr_defined_balances;
1043: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1044: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1045: P_VIRTUAL_DATE=>g_end_date),0);
1046: l_051_steering_code:=l_051_steering_code+l_value;
1047: END LOOP;

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

1050: l_balance_type_id:=csr_balance.balance_type_id;
1051: OPEN csr_defined_balances(l_balance_type_id);
1052: FETCH csr_defined_balances INTO l_defined_balance_id;
1053: CLOSE csr_defined_balances;
1054: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1055: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1056: P_VIRTUAL_DATE=>g_end_date),0);
1057: l_052_steering_code:=l_052_steering_code+l_value;
1058: END LOOP;

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

1061: l_balance_type_id:=csr_balance.balance_type_id;
1062: OPEN csr_defined_balances(l_balance_type_id);
1063: FETCH csr_defined_balances INTO l_defined_balance_id;
1064: CLOSE csr_defined_balances;
1065: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1066: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1067: P_VIRTUAL_DATE=>g_end_date),0);
1068: l_053_steering_code:=l_053_steering_code+l_value;
1069: END LOOP;

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

1072: l_balance_type_id:=csr_balance.balance_type_id;
1073: OPEN csr_defined_balances(l_balance_type_id);
1074: FETCH csr_defined_balances INTO l_defined_balance_id;
1075: CLOSE csr_defined_balances;
1076: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1077: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1078: P_VIRTUAL_DATE=>g_end_date),0);
1079: l_054_steering_code:=l_054_steering_code+l_value;
1080: END LOOP;

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

1083: l_balance_type_id:=csr_balance.balance_type_id;
1084: OPEN csr_defined_balances(l_balance_type_id);
1085: FETCH csr_defined_balances INTO l_defined_balance_id;
1086: CLOSE csr_defined_balances;
1087: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1088: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1089: P_VIRTUAL_DATE=>g_end_date),0);
1090: l_055_steering_code:=l_055_steering_code+l_value;
1091: END LOOP;

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

1094: l_balance_type_id:=csr_balance.balance_type_id;
1095: OPEN csr_defined_balances(l_balance_type_id);
1096: FETCH csr_defined_balances INTO l_defined_balance_id;
1097: CLOSE csr_defined_balances;
1098: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1099: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1100: P_VIRTUAL_DATE=>g_end_date),0);
1101: l_056_steering_code:=l_056_steering_code+l_value;
1102: END LOOP;

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

1105: l_balance_type_id:=csr_balance.balance_type_id;
1106: OPEN csr_defined_balances(l_balance_type_id);
1107: FETCH csr_defined_balances INTO l_defined_balance_id;
1108: CLOSE csr_defined_balances;
1109: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1110: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1111: P_VIRTUAL_DATE=>g_end_date),0);
1112: l_058_steering_code:=l_058_steering_code+l_value;
1113: END LOOP;

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

1116: l_balance_type_id:=csr_balance.balance_type_id;
1117: OPEN csr_defined_balances(l_balance_type_id);
1118: FETCH csr_defined_balances INTO l_defined_balance_id;
1119: CLOSE csr_defined_balances;
1120: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1121: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1122: P_VIRTUAL_DATE=>g_end_date),0);
1123: l_600_steering_code:=l_600_steering_code+l_value;
1124: END LOOP;

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

1127: l_balance_type_id:=csr_balance.balance_type_id;
1128: OPEN csr_defined_balances(l_balance_type_id);
1129: FETCH csr_defined_balances INTO l_defined_balance_id;
1130: CLOSE csr_defined_balances;
1131: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1132: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1133: P_VIRTUAL_DATE=>g_end_date),0);
1134: l_601_steering_code:=l_601_steering_code+l_value;
1135: END LOOP;

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

1138: l_balance_type_id:=csr_balance.balance_type_id;
1139: OPEN csr_defined_balances(l_balance_type_id);
1140: FETCH csr_defined_balances INTO l_defined_balance_id;
1141: CLOSE csr_defined_balances;
1142: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1143: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1144: P_VIRTUAL_DATE=>g_end_date),0);
1145: l_810_steering_code:=l_810_steering_code+l_value;
1146: END LOOP;

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

1149: l_balance_type_id:=csr_balance.balance_type_id;
1150: OPEN csr_defined_balances(l_balance_type_id);
1151: FETCH csr_defined_balances INTO l_defined_balance_id;
1152: CLOSE csr_defined_balances;
1153: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1154: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1155: P_VIRTUAL_DATE=>g_end_date),0);
1156: l_800_steering_code:=l_800_steering_code+l_value;
1157: END LOOP;

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

1160: l_balance_type_id:=csr_balance.balance_type_id;
1161: OPEN csr_defined_balances(l_balance_type_id);
1162: FETCH csr_defined_balances INTO l_defined_balance_id;
1163: CLOSE csr_defined_balances;
1164: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1165: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1166: P_VIRTUAL_DATE=>g_end_date),0);
1167: l_801_steering_code:=l_801_steering_code+l_value;
1168: END LOOP;

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

1171: l_balance_type_id:=csr_balance.balance_type_id;
1172: OPEN csr_defined_balances(l_balance_type_id);
1173: FETCH csr_defined_balances INTO l_defined_balance_id;
1174: CLOSE csr_defined_balances;
1175: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1176: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1177: P_VIRTUAL_DATE=>g_end_date),0);
1178: l_802_steering_code:=l_802_steering_code+l_value;
1179: END LOOP;

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

1182: l_balance_type_id:=csr_balance.balance_type_id;
1183: OPEN csr_defined_balances(l_balance_type_id);
1184: FETCH csr_defined_balances INTO l_defined_balance_id;
1185: CLOSE csr_defined_balances;
1186: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1187: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1188: P_VIRTUAL_DATE=>g_end_date),0);
1189: l_803_steering_code:=l_803_steering_code+l_value;
1190: END LOOP;

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

1193: l_balance_type_id:=csr_balance.balance_type_id;
1194: OPEN csr_defined_balances(l_balance_type_id);
1195: FETCH csr_defined_balances INTO l_defined_balance_id;
1196: CLOSE csr_defined_balances;
1197: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1198: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1199: P_VIRTUAL_DATE=>g_end_date),0);
1200: l_804_steering_code:=l_804_steering_code+l_value;
1201: END LOOP;

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

1204: l_balance_type_id:=csr_balance.balance_type_id;
1205: OPEN csr_defined_balances(l_balance_type_id);
1206: FETCH csr_defined_balances INTO l_defined_balance_id;
1207: CLOSE csr_defined_balances;
1208: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1209: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1210: P_VIRTUAL_DATE=>g_end_date),0);
1211: l_805_steering_code:=l_805_steering_code+l_value;
1212: END LOOP;

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

1215: l_balance_type_id:=csr_balance.balance_type_id;
1216: OPEN csr_defined_balances(l_balance_type_id);
1217: FETCH csr_defined_balances INTO l_defined_balance_id;
1218: CLOSE csr_defined_balances;
1219: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1220: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1221: P_VIRTUAL_DATE=>g_end_date),0);
1222: l_806_steering_code:=l_806_steering_code+l_value;
1223: END LOOP;

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

1226: l_balance_type_id:=csr_balance.balance_type_id;
1227: OPEN csr_defined_balances(l_balance_type_id);
1228: FETCH csr_defined_balances INTO l_defined_balance_id;
1229: CLOSE csr_defined_balances;
1230: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1231: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1232: P_VIRTUAL_DATE=>g_end_date),0);
1233: l_808_steering_code:=l_808_steering_code+l_value;
1234: END LOOP;

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

1373:
1374: OPEN csr_extra_assignment(l_assignment_id);
1375: FETCH csr_extra_assignment INTO l_work_type;
1376: CLOSE csr_extra_assignment;
1377: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1378: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1379:
1380: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
1381:

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

1374: OPEN csr_extra_assignment(l_assignment_id);
1375: FETCH csr_extra_assignment INTO l_work_type;
1376: CLOSE csr_extra_assignment;
1377: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1378: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1379:
1380: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
1381:
1382: l_balance_type_id:=csr_balance.balance_type_id;

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

1384: OPEN csr_defined_balances(l_balance_type_id);
1385: FETCH csr_defined_balances INTO l_defined_balance_id;
1386: CLOSE csr_defined_balances;
1387:
1388: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1389: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1390: P_VIRTUAL_DATE=>g_end_date),0);
1391:
1392: l_001_steering_code:=l_001_steering_code+l_value;

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

1397: l_balance_type_id:=csr_balance.balance_type_id;
1398: OPEN csr_defined_balances(l_balance_type_id);
1399: FETCH csr_defined_balances INTO l_defined_balance_id;
1400: CLOSE csr_defined_balances;
1401: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1402: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1403: P_VIRTUAL_DATE=>g_end_date),0);
1404: l_002_steering_code:=l_002_steering_code+l_value;
1405: END LOOP;

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

1408: l_balance_type_id:=csr_balance.balance_type_id;
1409: OPEN csr_defined_balances(l_balance_type_id);
1410: FETCH csr_defined_balances INTO l_defined_balance_id;
1411: CLOSE csr_defined_balances;
1412: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1413: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1414: P_VIRTUAL_DATE=>g_end_date),0);
1415: l_003_steering_code:=l_003_steering_code+l_value;
1416: END LOOP;

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

1419: l_balance_type_id:=csr_balance.balance_type_id;
1420: OPEN csr_defined_balances(l_balance_type_id);
1421: FETCH csr_defined_balances INTO l_defined_balance_id;
1422: CLOSE csr_defined_balances;
1423: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1424: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1425: P_VIRTUAL_DATE=>g_end_date),0);
1426: l_004_steering_code:=l_004_steering_code+l_value;
1427: END LOOP;

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

1430: l_balance_type_id:=csr_balance.balance_type_id;
1431: OPEN csr_defined_balances(l_balance_type_id);
1432: FETCH csr_defined_balances INTO l_defined_balance_id;
1433: CLOSE csr_defined_balances;
1434: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1435: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1436: P_VIRTUAL_DATE=>g_end_date),0);
1437: l_051_steering_code:=l_051_steering_code+l_value;
1438: END LOOP;

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

1441: l_balance_type_id:=csr_balance.balance_type_id;
1442: OPEN csr_defined_balances(l_balance_type_id);
1443: FETCH csr_defined_balances INTO l_defined_balance_id;
1444: CLOSE csr_defined_balances;
1445: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1446: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1447: P_VIRTUAL_DATE=>g_end_date),0);
1448: l_052_steering_code:=l_052_steering_code+l_value;
1449: END LOOP;

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

1452: l_balance_type_id:=csr_balance.balance_type_id;
1453: OPEN csr_defined_balances(l_balance_type_id);
1454: FETCH csr_defined_balances INTO l_defined_balance_id;
1455: CLOSE csr_defined_balances;
1456: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1457: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1458: P_VIRTUAL_DATE=>g_end_date),0);
1459: l_053_steering_code:=l_053_steering_code+l_value;
1460: END LOOP;

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

1463: l_balance_type_id:=csr_balance.balance_type_id;
1464: OPEN csr_defined_balances(l_balance_type_id);
1465: FETCH csr_defined_balances INTO l_defined_balance_id;
1466: CLOSE csr_defined_balances;
1467: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1468: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1469: P_VIRTUAL_DATE=>g_end_date),0);
1470: l_054_steering_code:=l_054_steering_code+l_value;
1471: END LOOP;

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

1474: l_balance_type_id:=csr_balance.balance_type_id;
1475: OPEN csr_defined_balances(l_balance_type_id);
1476: FETCH csr_defined_balances INTO l_defined_balance_id;
1477: CLOSE csr_defined_balances;
1478: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1479: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1480: P_VIRTUAL_DATE=>g_end_date),0);
1481: l_055_steering_code:=l_055_steering_code+l_value;
1482: END LOOP;

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

1485: l_balance_type_id:=csr_balance.balance_type_id;
1486: OPEN csr_defined_balances(l_balance_type_id);
1487: FETCH csr_defined_balances INTO l_defined_balance_id;
1488: CLOSE csr_defined_balances;
1489: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1490: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1491: P_VIRTUAL_DATE=>g_end_date),0);
1492: l_056_steering_code:=l_056_steering_code+l_value;
1493: END LOOP;

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

1496: l_balance_type_id:=csr_balance.balance_type_id;
1497: OPEN csr_defined_balances(l_balance_type_id);
1498: FETCH csr_defined_balances INTO l_defined_balance_id;
1499: CLOSE csr_defined_balances;
1500: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1501: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1502: P_VIRTUAL_DATE=>g_end_date),0);
1503: l_058_steering_code:=l_058_steering_code+l_value;
1504: END LOOP;

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

1507: l_balance_type_id:=csr_balance.balance_type_id;
1508: OPEN csr_defined_balances(l_balance_type_id);
1509: FETCH csr_defined_balances INTO l_defined_balance_id;
1510: CLOSE csr_defined_balances;
1511: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1512: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1513: P_VIRTUAL_DATE=>g_end_date),0);
1514: l_600_steering_code:=l_600_steering_code+l_value;
1515: END LOOP;

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

1518: l_balance_type_id:=csr_balance.balance_type_id;
1519: OPEN csr_defined_balances(l_balance_type_id);
1520: FETCH csr_defined_balances INTO l_defined_balance_id;
1521: CLOSE csr_defined_balances;
1522: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1523: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1524: P_VIRTUAL_DATE=>g_end_date),0);
1525: l_601_steering_code:=l_601_steering_code+l_value;
1526: END LOOP;

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

1529: l_balance_type_id:=csr_balance.balance_type_id;
1530: OPEN csr_defined_balances(l_balance_type_id);
1531: FETCH csr_defined_balances INTO l_defined_balance_id;
1532: CLOSE csr_defined_balances;
1533: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1534: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1535: P_VIRTUAL_DATE=>g_end_date),0);
1536: l_810_steering_code:=l_810_steering_code+l_value;
1537: END LOOP;

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

1540: l_balance_type_id:=csr_balance.balance_type_id;
1541: OPEN csr_defined_balances(l_balance_type_id);
1542: FETCH csr_defined_balances INTO l_defined_balance_id;
1543: CLOSE csr_defined_balances;
1544: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1545: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1546: P_VIRTUAL_DATE=>g_end_date),0);
1547: l_800_steering_code:=l_800_steering_code+l_value;
1548: END LOOP;

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

1551: l_balance_type_id:=csr_balance.balance_type_id;
1552: OPEN csr_defined_balances(l_balance_type_id);
1553: FETCH csr_defined_balances INTO l_defined_balance_id;
1554: CLOSE csr_defined_balances;
1555: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1556: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1557: P_VIRTUAL_DATE=>g_end_date),0);
1558: l_801_steering_code:=l_801_steering_code+l_value;
1559: END LOOP;

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

1562: l_balance_type_id:=csr_balance.balance_type_id;
1563: OPEN csr_defined_balances(l_balance_type_id);
1564: FETCH csr_defined_balances INTO l_defined_balance_id;
1565: CLOSE csr_defined_balances;
1566: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1567: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1568: P_VIRTUAL_DATE=>g_end_date),0);
1569: l_802_steering_code:=l_802_steering_code+l_value;
1570: END LOOP;

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

1573: l_balance_type_id:=csr_balance.balance_type_id;
1574: OPEN csr_defined_balances(l_balance_type_id);
1575: FETCH csr_defined_balances INTO l_defined_balance_id;
1576: CLOSE csr_defined_balances;
1577: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1578: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1579: P_VIRTUAL_DATE=>g_end_date),0);
1580: l_803_steering_code:=l_803_steering_code+l_value;
1581: END LOOP;

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

1584: l_balance_type_id:=csr_balance.balance_type_id;
1585: OPEN csr_defined_balances(l_balance_type_id);
1586: FETCH csr_defined_balances INTO l_defined_balance_id;
1587: CLOSE csr_defined_balances;
1588: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1589: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1590: P_VIRTUAL_DATE=>g_end_date),0);
1591: l_804_steering_code:=l_804_steering_code+l_value;
1592: END LOOP;

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

1595: l_balance_type_id:=csr_balance.balance_type_id;
1596: OPEN csr_defined_balances(l_balance_type_id);
1597: FETCH csr_defined_balances INTO l_defined_balance_id;
1598: CLOSE csr_defined_balances;
1599: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1600: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1601: P_VIRTUAL_DATE=>g_end_date),0);
1602: l_805_steering_code:=l_805_steering_code+l_value;
1603: END LOOP;

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

1606: l_balance_type_id:=csr_balance.balance_type_id;
1607: OPEN csr_defined_balances(l_balance_type_id);
1608: FETCH csr_defined_balances INTO l_defined_balance_id;
1609: CLOSE csr_defined_balances;
1610: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1611: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1612: P_VIRTUAL_DATE=>g_end_date),0);
1613: l_806_steering_code:=l_806_steering_code+l_value;
1614: END LOOP;

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

1617: l_balance_type_id:=csr_balance.balance_type_id;
1618: OPEN csr_defined_balances(l_balance_type_id);
1619: FETCH csr_defined_balances INTO l_defined_balance_id;
1620: CLOSE csr_defined_balances;
1621: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1622: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1623: P_VIRTUAL_DATE=>g_end_date),0);
1624: l_808_steering_code:=l_808_steering_code+l_value;
1625: END LOOP;

Line 1866: (pay_balance_pkg.get_value

1862: CLOSE csr_def_bal_id;
1863:
1864: l_return_balance_value :=
1865: TO_CHAR
1866: (pay_balance_pkg.get_value
1867: (p_defined_balance_id => l_defined_balance_id
1868: , p_assignment_id => p_in_assignment_id
1869: , p_virtual_date => p_in_virtual_date
1870: )