DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on GMD_SAMPLING_PLANS

Line 205: FROM gmd_all_spec_vrs s, gmd_sampling_plans b

201:
202: /*CURSOR c_get_sample_cnt (p_spec_vr_id NUMBER)
203: IS
204: SELECT b.sample_cnt_req
205: FROM gmd_all_spec_vrs s, gmd_sampling_plans b
206: WHERE s.spec_vr_id = p_spec_vr_id
207: AND s.sampling_plan_id = b.sampling_plan_id;*/
208:
209: --CURSOR c_get_sample_cnt rewritten as part of bug# 4916871

Line 224: select spec_vr_id, sampling_plan_id from gmd_stability_spec_vrs) s, gmd_sampling_plans b

220: select spec_vr_id, sampling_plan_id from gmd_supplier_spec_vrs
221: union all
222: select spec_vr_id, sampling_plan_id from gmd_monitoring_spec_vrs
223: union all
224: select spec_vr_id, sampling_plan_id from gmd_stability_spec_vrs) s, gmd_sampling_plans b
225: WHERE s.spec_vr_id = p_spec_vr_id
226: AND s.sampling_plan_id = b.sampling_plan_id;
227:
228: -- Cursors