APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_ROUTES_APP_V

Line 1542: AND ROUTE_ID IN (SELECT ROUTE_ID FROM AHL_ROUTES_APP_V

1538:
1539: SELECT COUNT(*) INTO l_counter
1540: FROM AHL_MR_ROUTES A
1541: WHERE MR_HEADER_ID=l_activity_id
1542: AND ROUTE_ID IN (SELECT ROUTE_ID FROM AHL_ROUTES_APP_V
1543: WHERE ROUTE_ID=A.ROUTE_id
1544: AND NVL(END_DATE_ACTIVE,SYSDATE+1)>SYSDATE
1545: AND REVISION_STATUS_CODE='COMPLETE');
1546: