APPS.AHL_RM_ROUTE_UTIL dependencies on FND_PROFILE
Line 3157: APPLICATION_USG_CODE=rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE')));
3153: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
3154: SELECT ROUTE_NO
3155: FROM AHL_ROUTES_B
3156: WHERE ROUTE_ID = c_route_id AND 3157: APPLICATION_USG_CODE=rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE'))); 3158: /* SELECT ROUTE_NO
3159: FROM AHL_ROUTES_V
3160: WHERE ROUTE_ID = c_route_id;*/
3161: