DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_MONITORING_SPEC_VRS

Line 386: -- gmd_monitoring_spec_vrs svr,

382: CURSOR c_res_sampling_event IS
383: SELECT se.sampling_event_id
384: FROM gmd_sampling_events se,
385: -- gmd_specifications_b s,
386: -- gmd_monitoring_spec_vrs svr,
387: gmd_event_spec_disp esd
388: -- WHERE s.spec_id = svr.spec_id
389: -- AND svr.spec_vr_id = esd.spec_vr_id
390: WHERE esd.sampling_event_id = se.sampling_event_id

Line 432: -- gmd_monitoring_spec_vrs svr,

428: CURSOR c_loc_sampling_event IS
429: SELECT se.sampling_event_id
430: FROM gmd_sampling_events se,
431: -- gmd_specifications_b s,
432: -- gmd_monitoring_spec_vrs svr,
433: gmd_event_spec_disp esd
434: -- WHERE s.spec_id = svr.spec_id
435: -- AND svr.spec_vr_id = esd.spec_vr_id
436: WHERE esd.sampling_event_id = se.sampling_event_id

Line 785: gmd_monitoring_spec_vrs svr,

781: CURSOR c_res_sampling_event IS
782: SELECT se.sampling_event_id
783: FROM gmd_sampling_events se,
784: gmd_specifications_b s,
785: gmd_monitoring_spec_vrs svr,
786: gmd_event_spec_disp esd
787: WHERE s.spec_id = svr.spec_id
788: AND svr.spec_vr_id = esd.spec_vr_id
789: AND esd.sampling_event_id = se.sampling_event_id

Line 828: gmd_monitoring_spec_vrs svr,

824: CURSOR c_loc_sampling_event IS
825: SELECT se.sampling_event_id
826: FROM gmd_sampling_events se,
827: gmd_specifications_b s,
828: gmd_monitoring_spec_vrs svr,
829: gmd_event_spec_disp esd
830: WHERE s.spec_id = svr.spec_id
831: AND svr.spec_vr_id = esd.spec_vr_id
832: AND esd.sampling_event_id = se.sampling_event_id