APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 341: from AHL_MR_HEADERS_APP_V

337: -- AHL_FMP_MR_SELCT_RT_FROM_LOV (ROUTE_NUMBER
338: CURSOR GetMrDet(c_mr_header_id NUMBER)
339: IS
340: SELECT MR_STATUS_CODE,TYPE_CODE
341: from AHL_MR_HEADERS_APP_V
342: where MR_HEADER_ID=c_mr_header_id
343: and MR_STATUS_CODE in('DRAFT','APPROVAL_REJECTED');
344:
345: l_mr_rec GetMrDet%rowtype;

Line 446: SELECT program_type_code INTO l_mr_prog_type FROM ahl_mr_headers_app_v WHERE mr_header_id = p_x_mr_route_rec.mr_header_id;

442:
443: -- Tamal [MEL/CDL] -- Begin changes
444: IF (p_x_mr_route_rec.dml_operation <> 'D')
445: THEN
446: SELECT program_type_code INTO l_mr_prog_type FROM ahl_mr_headers_app_v WHERE mr_header_id = p_x_mr_route_rec.mr_header_id;
447: SELECT route_type_code INTO l_route_type FROM ahl_routes_app_v WHERE route_id = p_x_mr_route_rec.route_id;
448:
449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
450: THEN