APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on CS_INCIDENT_STATUSES

Line 99: FROM cs_incident_statuses

95: incident_postal_code, incident_state, incident_province, incident_county,
96: incident_location_type
97: FROM cs_incidents_all_b
98: WHERE incident_status_id IN (SELECT incident_status_id
99: FROM cs_incident_statuses
100: WHERE NVL(close_flag,'N') <> 'Y' AND incident_subtype = 'INC')
101: AND NVL(owner_assigned_flag,'N') <> 'Y'
102: AND (((p_group1_id IS NOT NULL
103: OR p_group2_id IS NOT NULL

Line 1556: FROM cs_incident_statuses_vl

1552: WHERE incident_severity_id = l_sev1_id
1553: AND incident_owner_id = l_resource_id
1554: AND incident_status_id NOT IN (
1555: SELECT incident_status_id
1556: FROM cs_incident_statuses_vl
1557: WHERE incident_subtype = 'INC'
1558: AND close_flag = 'Y');
1559:
1560: CURSOR c_sev2_cnt(l_sev2_id NUMBER ,l_resource_id NUMBER) IS

Line 1567: FROM cs_incident_statuses_vl

1563: WHERE incident_severity_id = l_sev2_id
1564: AND incident_owner_id = l_resource_id
1565: AND incident_status_id NOT IN (
1566: SELECT incident_status_id
1567: FROM cs_incident_statuses_vl
1568: WHERE incident_subtype = 'INC'
1569: AND close_flag = 'Y');
1570:
1571: CURSOR c_sev3_cnt(l_sev3_id NUMBER,l_resource_id NUMBER) IS

Line 1578: FROM cs_incident_statuses_vl

1574: WHERE incident_severity_id = l_sev3_id
1575: AND incident_owner_id = l_resource_id
1576: AND incident_status_id NOT IN (
1577: SELECT incident_status_id
1578: FROM cs_incident_statuses_vl
1579: WHERE incident_subtype = 'INC'
1580: AND close_flag = 'Y');
1581:
1582: CURSOR c_sev4_cnt(l_sev4_id NUMBER,l_resource_id NUMBER) IS

Line 1589: FROM cs_incident_statuses_vl

1585: WHERE incident_severity_id = l_sev4_id
1586: AND incident_owner_id = l_resource_id
1587: AND incident_status_id NOT IN (
1588: SELECT incident_status_id
1589: FROM cs_incident_statuses_vl
1590: WHERE incident_subtype = 'INC'
1591: AND close_flag = 'Y');
1592:
1593: CURSOR c_res_time_zone(p_resource_id NUMBER) IS