2849:
2850: CURSOR cs_severity_in_eam_priority
2851: IS
2852: SELECT 'x'
2853: FROM cs_incident_severities_vl csv,
2854: mfg_lookups mfl
2855: WHERE mfl.lookup_code = csv.incident_severity_id AND
2856: csv.incident_severity_id = p_x_nonroutine_rec.severity_id AND
2857: csv.incident_subtype = 'INC' AND
2951: THEN
2952: BEGIN
2953: SELECT incident_severity_id
2954: INTO p_x_nonroutine_rec.severity_id
2955: FROM cs_incident_severities_vl
2956: WHERE name = p_x_nonroutine_rec.severity_name and
2957: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
2958: EXCEPTION
2959: WHEN NO_DATA_FOUND THEN