APPS.CS_ASSIGN_RESOURCE_PKG dependencies on CS_INCIDENT_STATUSES_VL

Line 1488: FROM cs_incident_statuses_vl

1484: WHERE incident_severity_id = l_sev1_id
1485: AND incident_owner_id = l_resource_id
1486: AND incident_status_id NOT IN (
1487: SELECT incident_status_id
1488: FROM cs_incident_statuses_vl
1489: WHERE incident_subtype = 'INC'
1490: AND close_flag = 'Y');
1491:
1492: CURSOR c_sev2_cnt(l_sev2_id NUMBER ,l_resource_id NUMBER) IS

Line 1499: FROM cs_incident_statuses_vl

1495: WHERE incident_severity_id = l_sev2_id
1496: AND incident_owner_id = l_resource_id
1497: AND incident_status_id NOT IN (
1498: SELECT incident_status_id
1499: FROM cs_incident_statuses_vl
1500: WHERE incident_subtype = 'INC'
1501: AND close_flag = 'Y');
1502:
1503: CURSOR c_sev3_cnt(l_sev3_id NUMBER,l_resource_id NUMBER) IS

Line 1510: FROM cs_incident_statuses_vl

1506: WHERE incident_severity_id = l_sev3_id
1507: AND incident_owner_id = l_resource_id
1508: AND incident_status_id NOT IN (
1509: select incident_status_id
1510: FROM cs_incident_statuses_vl
1511: WHERE incident_subtype = 'INC'
1512: AND close_flag = 'Y');
1513:
1514: CURSOR c_sev4_cnt(l_sev4_id NUMBER,l_resource_id NUMBER) IS

Line 1521: FROM cs_incident_statuses_vl

1517: WHERE incident_severity_id = l_sev4_id
1518: AND incident_owner_id = l_resource_id
1519: AND incident_status_id NOT IN (
1520: SELECT incident_status_id
1521: FROM cs_incident_statuses_vl
1522: WHERE incident_subtype = 'INC'
1523: AND close_flag = 'Y');
1524:
1525: CURSOR c_res_time_zone(p_resource_id NUMBER) IS