APPS.GMD_QUALITY_GRP dependencies on GMD_QC_TESTS_B

Line 250: l_test_type gmd_qc_tests_b.test_type%TYPE;

246: l_return_status VARCHAR2(1);
247: l_composite_spec_disp_id NUMBER;
248: i NUMBER := 0;
249: l_row_num NUMBER := 0;
250: l_test_type gmd_qc_tests_b.test_type%TYPE;
251: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
252: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
253: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;

Line 281: FROM gmd_qc_tests_b

277: ;
278:
279: Cursor get_qc_tests(vTest_id NUMBER) IS
280: SELECT test_type, min_value_num, max_value_num, display_precision
281: FROM gmd_qc_tests_b
282: WHERE test_id = vTest_id;
283:
284: Cursor get_spec_tests(vSpec_id NUMBER,
285: vTest_id NUMBER) IS

Line 315: FROM gmd_qc_tests_b

311:
312: -- get display precision for composite results
313: CURSOR get_tst_display_precision(vTest_id NUMBER) IS
314: SELECT display_precision
315: FROM gmd_qc_tests_b
316: WHERE test_id = vTest_id;
317:
318: l_test_found BOOLEAN := FALSE;
319: l_disp_precision NUMBER;

Line 702: FROM gmd_spec_tests_b st, gmd_qc_tests_b qt

698: st.min_value_char, st.min_value_num ,
699: st.max_value_char, st.max_value_num ,
700: qt.test_type, st.spec_id,
701: NVL(st.display_precision, qt.display_precision) display_precision
702: FROM gmd_spec_tests_b st, gmd_qc_tests_b qt
703: WHERE st.spec_id = vSpec_id
704: AND st.test_id = vTest_id
705: AND st.test_id = qt.test_id;
706: