APPS.GMD_RESULTS_PUB dependencies on GMD_SAMPLE_SPEC_DISP

Line 101: FROM gmd_event_spec_disp e , gmd_sample_spec_disp s , gmd_sampling_events se

97: CURSOR c_get_event_spec (p_sampling_event_id NUMBER, p_sample_id NUMBER)
98: IS
99: SELECT e.event_spec_disp_id, s.disposition , e.spec_id,
100: se.sample_req_cnt, se.sample_active_cnt
101: FROM gmd_event_spec_disp e , gmd_sample_spec_disp s , gmd_sampling_events se
102: WHERE s.event_spec_disp_id = e.event_spec_disp_id
103: AND se.sampling_event_id = e.sampling_event_id
104: AND se.sampling_event_id = p_sampling_event_id
105: AND s.sample_id = p_sample_id