APPS.GMD_SAMPLES_PUB dependencies on GMD_SPECIFICATIONS

Line 193: l_spec_type GMD_SPECIFICATIONS.SPEC_TYPE%TYPE;

189: l_spec_vr_id NUMBER;
190: l_spec_id NUMBER;
191: l_sampling_plan_id NUMBER;
192: l_date DATE := SYSDATE;
193: l_spec_type GMD_SPECIFICATIONS.SPEC_TYPE%TYPE;
194: l_sampling_event_exist VARCHAR2(1);
195:
196: -- Bug 4165704: needed to fetch values from quality config table
197: quality_config GMD_QUALITY_CONFIG%ROWTYPE;