APPS.AHL_VWP_TASKS_PVT dependencies on AHL_MR_ROUTES

Line 519: AHL_MR_ROUTES AMRR,

515: FROM AHL_VISITS_B AVTS,
516: AHL_VISIT_TASKS_B ATSK,
517: AHL_VISIT_TASKS_TL ATSKL,
518: AHL_VISIT_TASKS_VL ORIGTSK,
519: AHL_MR_ROUTES AMRR,
520: AHL_MR_HEADERS_VL AMRH,
521: AHL_UNIT_EFFECTIVITIES_B AUEF,
522: CSI_ITEM_INSTANCES CSIS,
523: CS_INCIDENTS_ALL_B SR,

Line 771: FROM AHL_MR_ROUTES A, AHL_MR_HEADERS_APP_V B

767:
768: -- To find task's route related information
769: CURSOR c_route (p_mr_route_id IN NUMBER) IS
770: SELECT A.ROUTE_ID
771: FROM AHL_MR_ROUTES A, AHL_MR_HEADERS_APP_V B
772: WHERE A.MR_HEADER_ID=B.MR_HEADER_ID
773: AND A.MR_ROUTE_ID = p_mr_route_id;
774:
775: -- To find task's unit effectivity tolerance related information