APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on GEM_LOOKUPS

Line 301: FROM GEM_LOOKUPS

297: --RLNAGARA Bug # 4706861
298:
299: IF disp_attr_rec.SPEC_TYPE IS NOT NULL THEN
300: SELECT DESCRIPTION INTO l_spectype_desc
301: FROM GEM_LOOKUPS
302: WHERE LOOKUP_TYPE = 'GMD_QC_SPEC_TYPE'
303: AND LOOKUP_CODE = disp_attr_rec.SPEC_TYPE ;
304: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_TYPE', l_spectype_desc);
305: END IF;