APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on AHL_ROUTES_B

Line 925: FROM AHL_ROUTES_B

921:
922: CURSOR get_latest_route_rev (p_enigma_route_id VARCHAR2)
923: IS
924: SELECT route_id,object_version_number,revision_status_code revision_status
925: FROM AHL_ROUTES_B
926: WHERE UPPER(TRIM(ENIGMA_ROUTE_ID)) = UPPER(TRIM(p_enigma_route_id))
927: AND REVISION_NUMBER =(
928: SELECT MAX( revision_number )
929: FROM AHL_ROUTES_B

Line 929: FROM AHL_ROUTES_B

925: FROM AHL_ROUTES_B
926: WHERE UPPER(TRIM(ENIGMA_ROUTE_ID)) = UPPER(TRIM(p_enigma_route_id))
927: AND REVISION_NUMBER =(
928: SELECT MAX( revision_number )
929: FROM AHL_ROUTES_B
930: WHERE UPPER(TRIM(ENIGMA_ROUTE_ID)) = UPPER(TRIM(p_enigma_route_id)));
931:
932: --pekambar changes for bug # 9004971 --start
933:

Line 937: FROM AHL_ROUTES_B

933:
934: CURSOR validate_enig_route(p_enigma_route_id VARCHAR2)
935: IS
936: SELECT count(*)
937: FROM AHL_ROUTES_B
938: WHERE ENIGMA_ROUTE_ID = p_enigma_route_id;
939: --pekambar changes for bug # 9004971 --end
940:
941: -- Declare local variables

Line 1259: AHL_ROUTES_B where route_id = x_route_id;

1255: END IF;
1256:
1257: --to get the object version number of new revision
1258: SELECT object_version_number INTO l_ovn from
1259: AHL_ROUTES_B where route_id = x_route_id;
1260:
1261: Map_Enigma_To_CMRO_Route_Rec
1262: (
1263: p_enigma_route_rec,