APPS.AHL_ENIGMA_UTIL_PKG dependencies on AHL_ROUTES_B

Line 70: FROM ahl_workorders wo,ahl_routes_b rt

66: FROM dual;
67:
68: CURSOR get_doc_id (c_workorder_id NUMBER)IS
69: SELECT enigma_doc_id
70: FROM ahl_workorders wo,ahl_routes_b rt
71: WHERE wo.workorder_id = c_workorder_id
72: AND wo.route_id = rt.route_id;
73:
74: CURSOR get_wo_model_tail_csr (c_workorder NUMBER)

Line 91: FROM ahl_routes_b

87:
88: CURSOR c_get_route_details(c_route_id NUMBER)
89: IS
90: SELECT enigma_doc_id,model_code
91: FROM ahl_routes_b
92: WHERE route_id = c_route_id;
93:
94: p_relationship_id NUMBER;
95: l_instance_id NUMBER;

Line 290: FROM ahl_routes_b RT,ahl_workorders WO

286: l_doc_id := NULL;
287: BEGIN
288: SELECT enigma_doc_id
289: INTO l_doc_id
290: FROM ahl_routes_b RT,ahl_workorders WO
291: WHERE WO.workorder_id = p_workorder_id
292: AND WO.route_id = RT.route_id;
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN