APPS.AHL_VWP_TASKS_PVT dependencies on AHL_ROUTES_APP_V

Line 765: FROM AHL_ROUTES_APP_V

761: based on route time span as well as resource requirements
762: */
763: -- AnRaj: Changed query for perf issue#4, Bug 4919465
764: SELECT ZONE_CODE, SUB_ZONE_CODE
765: FROM AHL_ROUTES_APP_V
766: WHERE ROUTE_ID = p_route_id;
767:
768: -- To find task's route related information
769: CURSOR c_route (p_mr_route_id IN NUMBER) IS