APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_ROUTES_APP_V

Line 1936: AND ROUTE_ID IN (SELECT ROUTE_ID FROM AHL_ROUTES_APP_V

1932:
1933: SELECT COUNT(*) INTO l_counter
1934: FROM AHL_MR_ROUTES A
1935: WHERE MR_HEADER_ID=l_activity_id
1936: AND ROUTE_ID IN (SELECT ROUTE_ID FROM AHL_ROUTES_APP_V
1937: WHERE ROUTE_ID=A.ROUTE_id
1938: AND NVL(END_DATE_ACTIVE,SYSDATE+1)>SYSDATE
1939: AND REVISION_STATUS_CODE='COMPLETE');
1940: