APPS.GMD_SPEC_GRP dependencies on GMD_QC_TESTS_B

Line 380: FROM gmd_qc_tests_b

376:
377:
378: CURSOR cr_test(p_test_id NUMBER) IS
379: SELECT test_code,test_method_id,test_type,min_value_num,max_value_num,priority
380: FROM gmd_qc_tests_b
381: WHERE test_id = p_test_id
382: AND delete_mark = 0 ;
383:
384: CURSOR cr_test_method_valid(p_test_method_id NUMBER) IS

Line 399: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;

395:
396: l_temp VARCHAR2(1);
397: l_grade_ctl NUMBER(1);
398: l_test_type VARCHAR2(1);
399: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;
400: l_test_min_value_num NUMBER;
401: l_test_max_value_num NUMBER;
402: l_test_method_id NUMBER;
403: l_test_priority GMD_SPEC_TESTS_B.TEST_PRIORITY%TYPE;

Line 1458: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b

1454: x_return_status OUT NOCOPY VARCHAR2) IS
1455:
1456: CURSOR cr_expression_tests IS
1457: SELECT a.test_id,a.seq
1458: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b
1459: WHERE
1460: a.spec_id = p_spec_id
1461: AND a.test_id = b.test_id
1462: AND b.test_type = 'E' ;