APPS.GMD_QC_TEST_VALUES_GRP dependencies on GMD_QC_TESTS_B

Line 113: FROM GMD_QC_TESTS_B

109: return(null);
110: END IF;
111:
112: SELECT test_type INTO l_test_type
113: FROM GMD_QC_TESTS_B
114: WHERE test_id = p_test_id ;
115:
116: IF l_test_type = 'L' THEN
117: SELECT DISPLAY_LABEL_NUMERIC_RANGE INTO l_test_value_desc

Line 173: SELECT test_type,display_precision,delete_mark FROM GMD_QC_TESTS_B

169: l_progress VARCHAR2(3);
170: l_delete_mark NUMBER(5);
171:
172: CURSOR cr_get_test_type(l_test_id NUMBER) IS
173: SELECT test_type,display_precision,delete_mark FROM GMD_QC_TESTS_B
174: WHERE test_id = p_test_id ;
175:
176:
177: BEGIN

Line 545: UPDATE GMD_QC_TESTS_B

541: RETURN;
542: END IF;
543: END IF;
544:
545: UPDATE GMD_QC_TESTS_B
546: SET min_value_num = l_min_range,
547: max_value_num = l_max_range
548: WHERE
549: test_id = x_gmd_qc_tests_rec.test_id ;

Line 564: UPDATE GMD_QC_TESTS_B

560: INTO l_min_range,l_max_range
561: FROM GMD_QC_TEST_VALUES_B
562: WHERE test_id = x_gmd_qc_tests_rec.test_id;
563:
564: UPDATE GMD_QC_TESTS_B
565: SET min_value_num = l_min_range,
566: max_value_num = l_max_range
567: WHERE
568: test_id = x_gmd_qc_tests_rec.test_id ;