APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on CS_INCIDENTS_ALL_B

Line 8632: from ahl_repair_categories rc, cs_incidents_all_b cs

8628: -- check repair category for time limit.
8629: cursor get_repair_category_csr(p_cs_incident_id IN NUMBER)
8630: is
8631: select nvl(repair_time,0), cs.expected_resolution_date
8632: from ahl_repair_categories rc, cs_incidents_all_b cs
8633: where rc.sr_urgency_id(+) = cs.incident_urgency_id
8634: and cs.incident_id = p_cs_incident_id;
8635:
8636: -- Read immediate children of the SR.