DBA Data[Home] [Help]

APPS.IGI_GEN dependencies on IGI_LOOKUPS

Line 199: from IGI_LOOKUPS

195: l_return_meaning VARCHAR2(240);
196: BEGIN
197:
198: SELECT meaning into l_return_meaning
199: from IGI_LOOKUPS
200: WHERE LOOKUP_TYPE = l_lookup_type;
201:
202: return (l_return_meaning);
203: EXCEPTION

Line 299: from igi_lookups

295:
296: Function Get_Igi_Prompt(p_lookup_code in Varchar2) Return Varchar2 Is
297: Cursor Igi_Prompt Is
298: Select meaning
299: from igi_lookups
300: Where lookup_type = 'IGI_PROMPTS'
301: and lookup_code = p_lookup_code;
302: l_prompt varchar2(80);
303: Begin