DBA Data[Home] [Help]

APPS.GMD_DISP_PUB dependencies on GMD_COMPOSITE_RESULTS

Line 538: FROM gmd_composite_results

534: AND sr.delete_mark = 0;
535:
536: CURSOR cr_check_comp_results_in_spec IS
537: SELECT COUNT(1)
538: FROM gmd_composite_results
539: WHERE composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id
540: AND delete_mark = 0 ;
541:
542: CURSOR c_non_accept_w_spec_cr IS

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 558: gmd_composite_results cr

554:
555: CURSOR c_non_accept_wo_spec_cr IS
556: SELECT count(1)
557: FROM gmd_event_spec_disp esd, gmd_composite_spec_disp csd,
558: gmd_composite_results cr
559: WHERE csd.composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_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