APPS.CS_SR_UTIL_PKG dependencies on CS_INCIDENT_STATUSES

Line 227: FROM cs_incident_statuses

223: BEGIN
224:
225: SELECT name
226: INTO p_default_status
227: FROM cs_incident_statuses
228: WHERE incident_status_id = p_default_status_id
229: AND incident_subtype = 'INC'
230: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
231: AND trunc(nvl(end_date_active, sysdate));

Line 461: FROM cs_incident_statuses

457: IF (p_default_status_id IS NOT NULL) THEN
458: BEGIN
459: SELECT name
460: INTO p_default_status
461: FROM cs_incident_statuses
462: WHERE incident_status_id = p_default_status_id
463: AND incident_subtype = 'INC'
464: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
465: AND trunc(nvl(end_date_active, sysdate));