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: --pekambar Enigma Phase II changes -- start
94: CURSOR c_get_operation_details(c_operation_id NUMBER)
95: IS

Line 110: FROM ahl_routes_b ro, ahl_workorders wo

106: --apattark added for bug #9901534
107: CURSOR get_wo_model_csr (c_workorder NUMBER)
108: IS
109: SELECT ro.model_code
110: FROM ahl_routes_b ro, ahl_workorders wo
111: WHERE wo.route_id = ro.route_id
112: AND WO.workorder_id = c_workorder;
113: --pekambar Enigma Phase II changes -- end
114:

Line 351: FROM ahl_routes_b RT,ahl_workorders WO

347: l_doc_id := NULL;
348: BEGIN
349: SELECT enigma_doc_id
350: INTO l_doc_id
351: FROM ahl_routes_b RT,ahl_workorders WO
352: WHERE WO.workorder_id = p_workorder_id
353: AND WO.route_id = RT.route_id;
354: EXCEPTION
355: WHEN NO_DATA_FOUND THEN