APPS.XTR_IMPORT_DEAL_DATA dependencies on FND_LOOKUPS

Line 371: from fnd_lookups

367: p_value in out nocopy Varchar2
368: ) is
369: cursor translate_cursor is
370: select lookup_code
371: from fnd_lookups
372: where lookup_type=p_lookupType
373: and (upper(lookup_code)=upper(p_value) or upper(meaning)=upper(p_value))
374: and rownum=1;
375: v_oldValue Varchar2(80):=p_value;