APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on CS_INCIDENTS_ALL_B

Line 10121: from ahl_repair_categories rc, cs_incidents_all_b cs

10117: -- check repair category for time limit.
10118: cursor get_repair_category_csr(p_cs_incident_id IN NUMBER)
10119: is
10120: select nvl(repair_time,0), cs.expected_resolution_date
10121: from ahl_repair_categories rc, cs_incidents_all_b cs
10122: where rc.sr_urgency_id(+) = cs.incident_urgency_id
10123: and cs.incident_id = p_cs_incident_id;
10124:
10125: -- Read immediate children of the SR.

Line 16449: FROM ahl_unit_effectivities_b ue, cs_incidents_all_b cs

16445: -- get resolution date.
16446: BEGIN
16447: SELECT cs.expected_resolution_date
16448: INTO l_expected_resolution_date
16449: FROM ahl_unit_effectivities_b ue, cs_incidents_all_b cs
16450: WHERE ue.unit_effectivity_id = p_unit_effectivity_id
16451: AND cs.incident_id = ue.cs_incident_id;
16452: EXCEPTION
16453: WHEN OTHERS THEN