APPS.AHL_VWP_TASKS_PVT dependencies on AHL_MR_ROUTES

Line 576: AHL_MR_ROUTES AMRR,

572: FROM AHL_VISITS_B AVTS,
573: AHL_VISIT_TASKS_B ATSK,
574: AHL_VISIT_TASKS_TL ATSKL,
575: AHL_VISIT_TASKS_VL ORIGTSK,
576: AHL_MR_ROUTES AMRR,
577: AHL_MR_HEADERS_VL AMRH,
578: AHL_UNIT_EFFECTIVITIES_B AUEF,
579: CSI_ITEM_INSTANCES CSIS,
580: CS_INCIDENTS_ALL_B SR,

Line 889: FROM AHL_MR_ROUTES A, AHL_MR_HEADERS_APP_V B

885:
886: -- To find task's route related information
887: CURSOR c_route (p_mr_route_id IN NUMBER) IS
888: SELECT A.ROUTE_ID
889: FROM AHL_MR_ROUTES A, AHL_MR_HEADERS_APP_V B
890: WHERE A.MR_HEADER_ID=B.MR_HEADER_ID
891: AND A.MR_ROUTE_ID = p_mr_route_id;
892:
893: -- To find task's unit effectivity tolerance related information