APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_MR_ROUTES_V

Line 2367: (SELECT DISTINCT(MR_Route_ID) "ROUTE_ID" FROM AHL_MR_ROUTES_V MR

2363: CURSOR c_route_chk(x_id IN NUMBER) IS
2364: SELECT DISTINCT(MR_Route_ID) "ROUTE_ID" FROM AHL_VISIT_TASKS_B TSK
2365: WHERE VISIT_ID = x_id AND MR_Route_ID IS NOT NULL
2366: AND NOT EXISTS
2367: (SELECT DISTINCT(MR_Route_ID) "ROUTE_ID" FROM AHL_MR_ROUTES_V MR
2368: where MR.mr_route_id =TSK.mr_route_id) and rownum=1;
2369:
2370: c_route_chk_rec c_route_chk%ROWTYPE;
2371: