DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_SPEC_TESTS_B

Line 4381: gmd_spec_tests_b spec

4377: Cursor Cur_find_max_dur IS
4378: SELECT qc.test_code, mthd.test_duration
4379: FROM gmd_qc_tests_vl qc,
4380: gmd_test_methods_b mthd,
4381: gmd_spec_tests_b spec
4382: WHERE qc.test_method_id = mthd.test_method_id
4383: AND qc.test_id = spec.test_id
4384: AND spec.spec_id = p_spec_id
4385: AND ( mthd.test_duration = (SELECT MAX(test_duration)

Line 4387: gmd_spec_tests_b spec2

4383: AND qc.test_id = spec.test_id
4384: AND spec.spec_id = p_spec_id
4385: AND ( mthd.test_duration = (SELECT MAX(test_duration)
4386: FROM gmd_test_methods_b mthd2,
4387: gmd_spec_tests_b spec2
4388: WHERE spec2.TEST_METHOD_ID = mthd2.test_method_id
4389: AND spec2.spec_id = p_spec_id));
4390:
4391: BEGIN