APPS.AHL_VWP_TASKS_PVT dependencies on AHL_ROUTES_APP_V

Line 883: FROM AHL_ROUTES_APP_V

879: based on route time span as well as resource requirements
880: */
881: -- AnRaj: Changed query for perf issue#4, Bug 4919465
882: SELECT ZONE_CODE, SUB_ZONE_CODE
883: FROM AHL_ROUTES_APP_V
884: WHERE ROUTE_ID = p_route_id;
885:
886: -- To find task's route related information
887: CURSOR c_route (p_mr_route_id IN NUMBER) IS