APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SPEC_TESTS

Line 512: FROM gmd_spec_tests s,

508: s.target_value_num, s.min_value_num, s.max_value_num,
509: s.target_value_char, s.min_value_char, s.max_value_char,
510: s.text_code spec_text_code,t.test_code,t.test_id,t.test_unit,
511: decode(m.test_method_code,'DEFAULT',NULL, m.test_method_code) test_method_code
512: FROM gmd_spec_tests s,
513: gmd_qc_tests t,
514: gmd_test_methods_b m
515: --Bug 3785184 backing out fix 3588346
516: -- gmd_results r, --BUG#3588346

Line 938: FROM GMD_SPEC_TESTS_B gst

934: --RLNAGARA Bug # 4916856
935: --Bug# 5223677. Pick all tests. Commented optional_ind condition.
936: CURSOR cr_get_req_spec_tests IS
937: SELECT gst.test_id
938: FROM GMD_SPEC_TESTS_B gst
939: WHERE gst.spec_id = p_spec_id;
940: -- AND gst.optional_ind is NULL ;
941:
942: