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:
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: