APPS.CS_ASSIGN_RESOURCE_PKG dependencies on CS_INCIDENT_STATUSES_VL

Line 1281: FROM cs_incident_statuses_vl

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
1281: FROM cs_incident_statuses_vl
1282: WHERE incident_subtype = 'INC'
1283: AND close_flag = 'Y');
1284:
1285: CURSOR c_sev2_cnt(l_sev2_id NUMBER ,l_resource_id NUMBER) IS

Line 1292: FROM cs_incident_statuses_vl

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
1292: FROM cs_incident_statuses_vl
1293: WHERE incident_subtype = 'INC'
1294: AND close_flag = 'Y');
1295:
1296: CURSOR c_sev3_cnt(l_sev3_id NUMBER,l_resource_id NUMBER) IS

Line 1303: FROM cs_incident_statuses_vl

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
1303: FROM cs_incident_statuses_vl
1304: WHERE incident_subtype = 'INC'
1305: AND close_flag = 'Y');
1306:
1307: CURSOR c_sev4_cnt(l_sev4_id NUMBER,l_resource_id NUMBER) IS

Line 1314: FROM cs_incident_statuses_vl

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
1314: FROM cs_incident_statuses_vl
1315: WHERE incident_subtype = 'INC'
1316: AND close_flag = 'Y');
1317:
1318: CURSOR c_res_time_zone(p_resource_id NUMBER) IS