APPS.CS_SR_UTIL_PKG dependencies on CS_INCIDENT_SEVERITIES

Line 168: FROM cs_incident_severities

164: BEGIN
165:
166: SELECT name
167: INTO p_default_severity
168: FROM cs_incident_severities
169: WHERE incident_severity_id = p_default_severity_id
170: AND incident_subtype = 'INC'
171: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
172: AND trunc(nvl(end_date_active, sysdate));

Line 341: FROM cs_incident_severities

337: IF (p_default_severity_id IS NOT NULL) THEN
338: BEGIN
339: SELECT name
340: INTO p_default_severity
341: FROM cs_incident_severities
342: WHERE incident_severity_id = p_default_severity_id
343: AND incident_subtype = 'INC'
344: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
345: AND trunc(nvl(end_date_active, sysdate));