APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_ROUTES_APP_V

Line 422: SELECT route_type_code INTO l_route_type FROM ahl_routes_app_v WHERE route_id = p_mr_route_rec.route_id;

418: -- Tamal [MEL/CDL] -- Begin changes
419: IF (p_mr_route_rec.dml_operation <> 'D')
420: THEN
421: SELECT program_type_code INTO l_mr_prog_type FROM ahl_mr_headers_app_v WHERE mr_header_id = p_mr_route_rec.mr_header_id;
422: SELECT route_type_code INTO l_route_type FROM ahl_routes_app_v WHERE route_id = p_mr_route_rec.route_id;
423:
424: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
425: THEN
426: fnd_log.string