APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTES_B_KFV

Line 2205: FROM AHL_ROUTES_B_KFV

2201:
2202: CURSOR get_concat_segs(c_route_id NUMBER)
2203: IS
2204: SELECT CONCATENATED_SEGMENTS
2205: FROM AHL_ROUTES_B_KFV
2206: WHERE ROUTE_ID = p_x_route_rec.route_id
2207: AND REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL;
2208:
2209:

Line 2214: FROM AHL_ROUTES_B_KFV

2210: --validate system KFV to ensure that no two routes share the same System KFV.
2211: CURSOR validate_system_kfv(c_route_no VARCHAR2, c_concat_segs VARCHAR2)
2212: IS
2213: SELECT 'X'
2214: FROM AHL_ROUTES_B_KFV
2215: WHERE REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL
2216: AND CONCATENATED_SEGMENTS = c_concat_segs
2217: AND ROUTE_NO <> c_route_no;
2218: --amsriniv. End