APPS.GMD_QC_TESTS_GRP dependencies on GMD_TEST_METHODS_B

Line 373: FROM GMD_TEST_METHODS_B

369:
370: IF p_test_method_id IS NOT NULL THEN
371: BEGIN
372: SELECT display_precision INTO l_test_method_precision
373: FROM GMD_TEST_METHODS_B
374: WHERE test_method_id = p_test_method_id ;
375:
376: EXCEPTION
377: WHEN NO_DATA_FOUND THEN

Line 771: SELECT 'x' FROM GMD_TEST_METHODS_B

767: x_return_status OUT NOCOPY VARCHAR2,
768: x_message_data OUT NOCOPY VARCHAR2) IS
769:
770: CURSOR cr_check_valid_test_method(p_test_method_id NUMBER) IS
771: SELECT 'x' FROM GMD_TEST_METHODS_B
772: WHERE test_method_id = p_test_method_id
773: AND delete_mark = 0;
774:
775: CURSOR cr_check_valid_test_class(p_test_class VARCHAR2) IS

Line 1387: gmd_test_methods_b c

1383: nvl(a.test_qty, c.test_qty) test_qty
1384: INTO l_test_qty_uom, l_test_qty
1385: FROM gmd_spec_tests a,
1386: gmd_qc_tests b,
1387: gmd_test_methods_b c
1388: WHERE a.spec_id = l_spec_id
1389: AND a.test_id = b.test_id
1390: AND b.test_id = l_test_id.test_id
1391: AND b.test_method_id = c.test_method_id;

Line 1396: FROM gmd_test_methods_b a, gmd_qc_tests b

1392: EXCEPTION
1393: WHEN NO_DATA_FOUND THEN
1394: SELECT a.test_qty_uom, a.test_qty
1395: INTO l_test_qty_uom, l_test_qty
1396: FROM gmd_test_methods_b a, gmd_qc_tests b
1397: WHERE b.test_id = l_test_id.test_id
1398: AND a.test_method_id = b.test_method_id;
1399: END;
1400: