APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on CS_INCIDENT_URGENCIES_VL

Line 1948: FROM cs_incident_urgencies_vl urg, ahl_repair_categories repcat

1944: p_repcat_name varchar2
1945: )
1946: IS
1947: SELECT repcat.repair_category_id
1948: FROM cs_incident_urgencies_vl urg, ahl_repair_categories repcat
1949: WHERE upper(urg.name) = upper(p_repcat_name) AND
1950: urg.incident_urgency_id = repcat.sr_urgency_id;
1951:
1952: BEGIN