DBA Data[Home] [Help]

APPS.GMD_SPEC_GRP dependencies on GMD_QC_TEST_VALUES_B

Line 1037: FROM gmd_qc_test_values_b

1033: AND spec_vers = p_spec_vers;
1034:
1035: CURSOR c_test_value (p_test_id NUMBER, p_value_char VARCHAR2) IS
1036: SELECT text_range_seq
1037: FROM gmd_qc_test_values_b
1038: WHERE test_id = p_test_id
1039: AND value_char = p_value_char ;
1040:
1041: CURSOR c_spec_type (p_spec_id NUMBER) IS

Line 1758: FROM gmd_qc_test_values_b

1754: RETURN BOOLEAN IS
1755:
1756: CURSOR c_test_values (p_exp_test_id NUMBER) IS
1757: SELECT EXPRESSION_REF_TEST_ID
1758: FROM gmd_qc_test_values_b
1759: WHERE test_id = p_exp_test_id;
1760:
1761: CURSOR c_spec_test (p_spec_id NUMBER, p_exp_test_seq NUMBER, p_ref_test_id NUMBER) IS
1762: SELECT 1

Line 1826: FROM gmd_qc_test_values_b

1822: RETURN BOOLEAN IS
1823:
1824: CURSOR cr_test_values IS
1825: SELECT '1'
1826: FROM gmd_qc_test_values_b
1827: WHERE test_id = p_test_id
1828: AND p_value >= nvl(min_num,p_value)
1829: AND p_value <= nvl(max_num,p_value);
1830: