APPS.CS_ASSIGN_RESOURCE_PKG dependencies on CS_INCIDENTS_ALL_B

Line 1265: FROM cs_incidents_all_b

1261:
1262:
1263: CURSOR c_time_last_login(l_resource_id NUMBER) is
1264: SELECT ROUND(((SYSDATE - nvl( max(owner_assigned_time),to_date('1990-01-01','yyyy-mm-dd'))) *24 * 60),2)
1265: FROM cs_incidents_all_b
1266: WHERE incident_owner_id = l_resource_id;
1267:
1268: CURSOR c_imp_level(p_inc_severity_id NUMBER) IS
1269: SELECT importance_level

Line 1276: FROM cs_incidents_all_b

1272: AND incident_severity_id = p_inc_severity_id;
1273:
1274: CURSOR c_sev1_cnt(l_sev1_id NUMBER,l_resource_id NUMBER) IS
1275: SELECT COUNT(*)
1276: FROM cs_incidents_all_b
1277: WHERE incident_severity_id = l_sev1_id
1278: AND incident_owner_id = l_resource_id
1279: AND incident_status_id NOT IN (
1280: SELECT incident_status_id

Line 1287: FROM cs_incidents_all_b

1283: AND close_flag = 'Y');
1284:
1285: CURSOR c_sev2_cnt(l_sev2_id NUMBER ,l_resource_id NUMBER) IS
1286: SELECT COUNT(*)
1287: FROM cs_incidents_all_b
1288: WHERE incident_severity_id = l_sev2_id
1289: AND incident_owner_id = l_resource_id
1290: AND incident_status_id NOT IN (
1291: SELECT incident_status_id

Line 1298: FROM cs_incidents_all_b

1294: AND close_flag = 'Y');
1295:
1296: CURSOR c_sev3_cnt(l_sev3_id NUMBER,l_resource_id NUMBER) IS
1297: SELECT COUNT(*)
1298: FROM cs_incidents_all_b
1299: WHERE incident_severity_id = l_sev3_id
1300: AND incident_owner_id = l_resource_id
1301: AND incident_status_id NOT IN (
1302: select incident_status_id

Line 1309: FROM cs_incidents_all_b

1305: AND close_flag = 'Y');
1306:
1307: CURSOR c_sev4_cnt(l_sev4_id NUMBER,l_resource_id NUMBER) IS
1308: SELECT COUNT(*)
1309: FROM cs_incidents_all_b
1310: WHERE incident_severity_id = l_sev4_id
1311: AND incident_owner_id = l_resource_id
1312: AND incident_status_id NOT IN (
1313: SELECT incident_status_id