335:
336: CURSOR c_get_range_with_disp(p_test_id NUMBER,
337: p_result NUMBER) IS
338: SELECT display_label_numeric_range
339: FROM gmd_qc_test_values
340: WHERE p_result between min_num and max_num
341: AND test_id = p_test_id;
342:
343: BEGIN
490:
491: CURSOR c_get_range_with_disp(p_test_id NUMBER,
492: p_result NUMBER) IS
493: SELECT display_label_numeric_range
494: FROM gmd_qc_test_values
495: WHERE p_result between min_num and max_num
496: AND test_id = p_test_id;
497:
498: l_get_cust_test c_get_cust_test%ROWTYPE;
611:
612: CURSOR c_get_range_with_disp(p_test_id NUMBER,
613: p_value NUMBER) IS
614: SELECT display_label_numeric_range
615: FROM gmd_qc_test_values
616: WHERE p_value between min_num and max_num
617: AND test_id = p_test_id;
618:
619: l_text VARCHAR2(240);