APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ROUTES_B

Line 3287: FROM AHL_ROUTES_B

3283:
3284: CURSOR get_route_status(c_route_id number) IS
3285: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
3286: SELECT ROUTE_NO
3287: FROM AHL_ROUTES_B
3288: WHERE ROUTE_ID = c_route_id AND
3289: APPLICATION_USG_CODE=rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE')));
3290: /* SELECT ROUTE_NO
3291: FROM AHL_ROUTES_V

Line 3869: FROM AHL_ROUTES_B r

3865:
3866: CURSOR get_rt_ApplnUsage( c_route_id NUMBER )
3867: IS
3868: SELECT r.Application_usg_code
3869: FROM AHL_ROUTES_B r
3870: WHERE r.route_id = c_route_id
3871: ;
3872:
3873: BEGIN