APPS.AHL_VWP_TIMES_PVT dependencies on AHL_ROUTES_B

Line 1478: FROM ahl_routes_b

1474: get_oprns_rec c_get_oprns%ROWTYPE;
1475:
1476: CURSOR c_get_route_time_span (c_route_id IN NUMBER) IS
1477: SELECT time_span
1478: FROM ahl_routes_b
1479: WHERE ROUTE_ID = c_route_id;
1480:
1481: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_task_duration';
1482: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name;