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
2952: mfl.lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY' AND