APPS.GMD_DISP_PUB dependencies on GMD_RESULTS

Line 511: gmd_results r,

507:
508: CURSOR c_non_accept_w_spec IS
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

Line 527: FROM gmd_results r, gmd_spec_results sr

523: AND ((l_include_optional = 'N' and st.optional_ind IS NULL) OR (l_include_optional = 'Y'));
524:
525: CURSOR c_non_accept_wo_spec IS
526: SELECT count(1)
527: FROM gmd_results r, gmd_spec_results sr
528: WHERE sr.event_spec_disp_id = p_update_disp_rec.event_spec_disp_id
529: AND sr.result_id = r.result_id
530: AND r.sample_id = p_update_disp_rec.sample_id
531: AND sr.additional_test_ind = 'Y'

Line 568: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,

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,
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

Line 582: FROM gmd_results r, gmd_spec_results sr

578: AND st.test_id = r.test_id ;
579:
580: CURSOR c_non_reject_wo_spec IS
581: SELECT count(1)
582: FROM gmd_results r, gmd_spec_results sr
583: WHERE sr.event_spec_disp_id = p_update_disp_rec.event_spec_disp_id
584: AND sr.result_id = r.result_id
585: AND r.sample_id = p_update_disp_rec.sample_id
586: AND sr.additional_test_ind = 'Y'

Line 593: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,

589: AND sr.delete_mark = 0;
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

Line 608: FROM gmd_results r, gmd_spec_results sr

604: AND ((l_include_optional = 'N' and st.optional_ind IS NULL) OR (l_include_optional = 'Y'));
605:
606: CURSOR c_reject_wo_spec_no_av IS
607: SELECT count(1)
608: FROM gmd_results r, gmd_spec_results sr
609: WHERE sr.event_spec_disp_id = p_update_disp_rec.event_spec_disp_id
610: AND sr.result_id = r.result_id
611: AND r.sample_id = p_update_disp_rec.sample_id
612: AND sr.additional_test_ind = 'Y'