DBA Data[Home] [Help]

APPS.CS_SR_UTIL_PKG dependencies on CS_INCIDENT_URGENCIES

Line 188: FROM cs_incident_urgencies

184: BEGIN
185:
186: SELECT name
187: INTO p_default_urgency
188: FROM cs_incident_urgencies
189: WHERE incident_urgency_id = p_default_urgency_id
190: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
191: AND trunc(nvl(end_date_active, sysdate));
192:

Line 360: FROM cs_incident_urgencies

356: IF (p_default_urgency_id IS NOT NULL) THEN
357: BEGIN
358: SELECT name
359: INTO p_default_urgency
360: FROM cs_incident_urgencies
361: WHERE incident_urgency_id = p_default_urgency_id
362: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
363: AND trunc(nvl(end_date_active, sysdate));
364: