APPS.GMD_SAMPLES_PUB dependencies on GMD_SPECIFICATIONS

Line 184: l_spec_type GMD_SPECIFICATIONS.SPEC_TYPE%TYPE;

180: l_spec_vr_id NUMBER;
181: l_spec_id NUMBER;
182: l_sampling_plan_id NUMBER;
183: l_date DATE := SYSDATE;
184: l_spec_type GMD_SPECIFICATIONS.SPEC_TYPE%TYPE;
185: l_sampling_event_exist VARCHAR2(1);
186:
187: -- Bug 4165704: needed to fetch values from quality config table
188: quality_config GMD_QUALITY_CONFIG%ROWTYPE;