2943:
2944: CURSOR cs_severity_in_eam_priority
2945: IS
2946: SELECT 'x'
2947: FROM cs_incident_severities_vl csv,
2948: mfg_lookups mfl
2949: WHERE mfl.lookup_code = csv.incident_severity_id AND
2950: csv.incident_severity_id = p_x_nonroutine_rec.severity_id AND
2951: csv.incident_subtype = 'INC' AND
3068: THEN
3069: BEGIN
3070: SELECT incident_severity_id
3071: INTO p_x_nonroutine_rec.severity_id
3072: FROM cs_incident_severities_vl
3073: WHERE name = p_x_nonroutine_rec.severity_name and
3074: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3075: EXCEPTION
3076: WHEN NO_DATA_FOUND THEN