APPS.GMD_QC_TESTS_GRP dependencies on GMD_QC_TESTS_B

Line 44: FROM GMD_QC_TESTS_B

40:
41: BEGIN
42: IF p_test_id IS NOT NULL THEN
43: SELECT 'X' INTO l_exists
44: FROM GMD_QC_TESTS_B
45: WHERE test_id = p_test_id ;
46: ELSE
47: SELECT 'X' INTO l_exists
48: FROM GMD_QC_TESTS_B

Line 48: FROM GMD_QC_TESTS_B

44: FROM GMD_QC_TESTS_B
45: WHERE test_id = p_test_id ;
46: ELSE
47: SELECT 'X' INTO l_exists
48: FROM GMD_QC_TESTS_B
49: WHERE test_code = p_test_code ;
50: END IF;
51:
52: RETURN TRUE;

Line 1285: FROM GMD_QC_TESTS_B

1281: BEGIN
1282: IF p_test_class IS NOT NULL AND
1283: p_test_group_order IS NOT NULL THEN
1284: SELECT 'X' INTO l_exists
1285: FROM GMD_QC_TESTS_B
1286: WHERE test_class = p_test_class
1287: AND test_group_order = p_test_group_order
1288: AND rownum =1 ;
1289: RETURN TRUE;

Line 1386: gmd_qc_tests b,

1382: SELECT nvl(a.test_qty_uom, c.test_qty_uom) test_qty_uom,
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

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: