APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on AHL_ROUTES_V

Line 432: FROM AHL_ROUTES_V

428: SELECT
429: route_id,
430: object_version_number,
431: revision_status_code revision_status
432: FROM AHL_ROUTES_V
433: WHERE UPPER(TRIM(ENIGMA_ROUTE_ID)) = UPPER(TRIM(p_route_id))
434: AND REVISION_NUMBER =
435: ( SELECT
436: MAX( revision_number )

Line 438: AHL_ROUTES_V

434: AND REVISION_NUMBER =
435: ( SELECT
436: MAX( revision_number )
437: FROM
438: AHL_ROUTES_V
439: WHERE
440: UPPER(TRIM(ENIGMA_ROUTE_ID)) = UPPER(TRIM(p_route_id)) );
441:
442: -- Declare local variables

Line 1006: AHL_ROUTES_V where route_id = x_route_id;

1002: */
1003: END IF;
1004:
1005: SELECT object_version_number INTO l_ovn from
1006: AHL_ROUTES_V where route_id = x_route_id;
1007:
1008: IF (l_ovn <> FND_API.G_MISS_NUM AND l_ovn IS NOT NULL ) THEN
1009: p_process_route_input_rec.object_version_number := l_ovn;
1010: END IF;