1459: WHERE incident_severity_id = l_sev1_id
1460: AND incident_owner_id = l_resource_id
1461: AND incident_status_id NOT IN (
1462: SELECT incident_status_id
1463: FROM cs_incident_statuses_vl
1464: WHERE incident_subtype = 'INC'
1465: AND close_flag = 'Y');
1466:
1467: CURSOR c_sev2_cnt(l_sev2_id NUMBER ,l_resource_id NUMBER) IS
1470: WHERE incident_severity_id = l_sev2_id
1471: AND incident_owner_id = l_resource_id
1472: AND incident_status_id NOT IN (
1473: SELECT incident_status_id
1474: FROM cs_incident_statuses_vl
1475: WHERE incident_subtype = 'INC'
1476: AND close_flag = 'Y');
1477:
1478: CURSOR c_sev3_cnt(l_sev3_id NUMBER,l_resource_id NUMBER) IS
1481: WHERE incident_severity_id = l_sev3_id
1482: AND incident_owner_id = l_resource_id
1483: AND incident_status_id NOT IN (
1484: SELECT incident_status_id
1485: FROM cs_incident_statuses_vl
1486: WHERE incident_subtype = 'INC'
1487: AND close_flag = 'Y');
1488:
1489: CURSOR c_sev4_cnt(l_sev4_id NUMBER,l_resource_id NUMBER) IS
1492: WHERE incident_severity_id = l_sev4_id
1493: AND incident_owner_id = l_resource_id
1494: AND incident_status_id NOT IN (
1495: SELECT incident_status_id
1496: FROM cs_incident_statuses_vl
1497: WHERE incident_subtype = 'INC'
1498: AND close_flag = 'Y');
1499:
1500: CURSOR c_res_time_zone(p_resource_id NUMBER) IS