APPS.GMD_DISP_PUB dependencies on GMD_SPEC_TESTS_B

Line 513: gmd_spec_tests_b st

509: SELECT count(1)
510: FROM gmd_event_spec_disp esd,
511: gmd_results r,
512: gmd_spec_results sr,
513: gmd_spec_tests_b st
514: WHERE esd.event_spec_disp_id = p_update_disp_rec.event_spec_disp_id
515: AND esd.event_spec_disp_id = sr.event_spec_disp_id
516: AND sr.result_id = r.result_id
517: AND r.sample_id = p_update_disp_rec.sample_id

Line 545: gmd_composite_results cr, gmd_spec_tests_b st

541:
542: CURSOR c_non_accept_w_spec_cr IS
543: SELECT count(1)
544: FROM gmd_event_spec_disp esd, gmd_composite_spec_disp csd,
545: gmd_composite_results cr, gmd_spec_tests_b st
546: WHERE csd.composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id
547: AND csd.event_spec_disp_id = esd.event_spec_disp_id
548: AND csd.latest_ind = 'Y'
549: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id

Line 564: AND cr.test_id NOT IN (SELECT st.test_id FROM gmd_spec_tests_b st WHERE st.spec_id = esd.spec_id);

560: AND csd.event_spec_disp_id = esd.event_spec_disp_id
561: AND csd.latest_ind = 'Y'
562: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id
563: AND cr.in_spec_ind IS NULL
564: AND cr.test_id NOT IN (SELECT st.test_id FROM gmd_spec_tests_b st WHERE st.spec_id = esd.spec_id);
565:
566: CURSOR c_non_reject_w_spec IS
567: SELECT count(1)
568: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,

Line 569: gmd_spec_tests_b st

565:
566: CURSOR c_non_reject_w_spec IS
567: SELECT count(1)
568: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,
569: gmd_spec_tests_b st
570: WHERE esd.event_spec_disp_id = p_update_disp_rec.event_spec_disp_id
571: AND esd.event_spec_disp_id = sr.event_spec_disp_id
572: AND sr.result_id = r.result_id
573: AND r.sample_id = p_update_disp_rec.sample_id

Line 594: gmd_spec_tests_b st

590:
591: CURSOR c_reject_w_spec_no_av IS
592: SELECT count(1)
593: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,
594: gmd_spec_tests_b st
595: WHERE esd.event_spec_disp_id = p_update_disp_rec.event_spec_disp_id
596: AND esd.event_spec_disp_id = sr.event_spec_disp_id
597: AND sr.result_id = r.result_id
598: AND r.sample_id = p_update_disp_rec.sample_id