APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_MR_ROUTES_V

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

1479: CURSOR c_route_chk(x_id IN NUMBER) IS
1480: SELECT DISTINCT(MR_Route_ID) "ROUTE_ID" FROM AHL_VISIT_TASKS_B TSK
1481: WHERE VISIT_ID = x_id AND MR_Route_ID IS NOT NULL
1482: AND NOT EXISTS
1483: (SELECT DISTINCT(MR_Route_ID) "ROUTE_ID" FROM AHL_MR_ROUTES_V MR
1484: where MR.mr_route_id =TSK.mr_route_id) and rownum=1;
1485:
1486: c_route_chk_rec c_route_chk%ROWTYPE;
1487: