APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on CS_INCIDENT_URGENCIES_VL

Line 1942: FROM cs_incident_urgencies_vl urg, ahl_repair_categories repcat

1938: p_repcat_name varchar2
1939: )
1940: IS
1941: SELECT repcat.repair_category_id
1942: FROM cs_incident_urgencies_vl urg, ahl_repair_categories repcat
1943: WHERE upper(urg.name) = upper(p_repcat_name) AND
1944: urg.incident_urgency_id = repcat.sr_urgency_id;
1945:
1946: BEGIN