APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 320: from AHL_MR_HEADERS_APP_V

316: -- AHL_FMP_MR_SELCT_RT_FROM_LOV (ROUTE_NUMBER
317: CURSOR GetMrDet(c_mr_header_id NUMBER)
318: IS
319: SELECT MR_STATUS_CODE,TYPE_CODE
320: from AHL_MR_HEADERS_APP_V
321: where MR_HEADER_ID=c_mr_header_id
322: and MR_STATUS_CODE in('DRAFT','APPROVAL_REJECTED');
323:
324: l_mr_rec GetMrDet%rowtype;

Line 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;

417:
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