APPS.GMD_SPEC_GRP dependencies on GMD_QC_TESTS_B

Line 359: FROM gmd_qc_tests_b

355:
356:
357: CURSOR cr_test(p_test_id NUMBER) IS
358: SELECT test_code,test_method_id,test_type,min_value_num,max_value_num,priority
359: FROM gmd_qc_tests_b
360: WHERE test_id = p_test_id
361: AND delete_mark = 0 ;
362:
363: CURSOR cr_test_method_valid(p_test_method_id NUMBER) IS

Line 378: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;

374:
375: l_temp VARCHAR2(1);
376: l_grade_ctl NUMBER(1);
377: l_test_type VARCHAR2(1);
378: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;
379: l_test_min_value_num NUMBER;
380: l_test_max_value_num NUMBER;
381: l_test_method_id NUMBER;
382: l_test_priority GMD_SPEC_TESTS_B.TEST_PRIORITY%TYPE;

Line 1386: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b

1382: x_return_status OUT NOCOPY VARCHAR2) IS
1383:
1384: CURSOR cr_expression_tests IS
1385: SELECT a.test_id,a.seq
1386: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b
1387: WHERE
1388: a.spec_id = p_spec_id
1389: AND a.test_id = b.test_id
1390: AND b.test_type = 'E' ;