DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_MONITORING_SPEC_VRS

Line 341: -- gmd_monitoring_spec_vrs svr,

337: CURSOR c_res_sampling_event IS
338: SELECT se.sampling_event_id
339: FROM gmd_sampling_events se,
340: -- gmd_specifications_b s,
341: -- gmd_monitoring_spec_vrs svr,
342: gmd_event_spec_disp esd
343: -- WHERE s.spec_id = svr.spec_id
344: -- AND svr.spec_vr_id = esd.spec_vr_id
345: WHERE esd.sampling_event_id = se.sampling_event_id

Line 387: -- gmd_monitoring_spec_vrs svr,

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

Line 710: gmd_monitoring_spec_vrs svr,

706: CURSOR c_res_sampling_event IS
707: SELECT se.sampling_event_id
708: FROM gmd_sampling_events se,
709: gmd_specifications_b s,
710: gmd_monitoring_spec_vrs svr,
711: gmd_event_spec_disp esd
712: WHERE s.spec_id = svr.spec_id
713: AND svr.spec_vr_id = esd.spec_vr_id
714: AND esd.sampling_event_id = se.sampling_event_id

Line 753: gmd_monitoring_spec_vrs svr,

749: CURSOR c_loc_sampling_event IS
750: SELECT se.sampling_event_id
751: FROM gmd_sampling_events se,
752: gmd_specifications_b s,
753: gmd_monitoring_spec_vrs svr,
754: gmd_event_spec_disp esd
755: WHERE s.spec_id = svr.spec_id
756: AND svr.spec_vr_id = esd.spec_vr_id
757: AND esd.sampling_event_id = se.sampling_event_id