APPS.GMD_SAMPLES_PUB dependencies on GMD_STABILITY_SPEC_VRS

Line 116: select spec_vr_id, NULL sample_inv_trans_ind from gmd_stability_spec_vrs) s

112: select spec_vr_id, sample_inv_trans_ind from gmd_supplier_spec_vrs
113: union all
114: select spec_vr_id, NULL sample_inv_trans_ind from gmd_monitoring_spec_vrs
115: union all
116: select spec_vr_id, NULL sample_inv_trans_ind from gmd_stability_spec_vrs) s
117: WHERE s.spec_vr_id = p_spec_vr_id ;
118: ELSE
119: IF p_spec_type = 'I' THEN
120: SELECT SAMPLE_INV_TRANS_IND INTO l_sample_inv_trans_ind

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

230: select spec_vr_id, sampling_plan_id from gmd_supplier_spec_vrs
231: union all
232: select spec_vr_id, sampling_plan_id from gmd_monitoring_spec_vrs
233: union all
234: select spec_vr_id, sampling_plan_id from gmd_stability_spec_vrs) s, gmd_sampling_plans b
235: WHERE s.spec_vr_id = p_spec_vr_id
236: AND s.sampling_plan_id = b.sampling_plan_id;
237:
238: -- Cursors