DBA Data[Home] [Help]

APPS.WFA_HTML_UTIL dependencies on WF_LOOKUPS

Line 264: from WF_LOOKUPS

260: submit in boolean)
261: as
262: cursor lookup_codes(p_lookup_type varchar2) is
263: select MEANING, LOOKUP_CODE
264: from WF_LOOKUPS
265: where LOOKUP_TYPE = p_lookup_type
266: order by MEANING;
267:
268: template varchar2(4000);

Line 335: from WF_LOOKUPS

331: indexer number := otherattr;
332:
333: cursor lookup_codes(p_lookup_type varchar2) is
334: select MEANING, LOOKUP_CODE
335: from WF_LOOKUPS
336: where LOOKUP_TYPE = p_lookup_type
337: order by MEANING;
338: begin
339: -- Check number of response values.

Line 343: from WF_LOOKUPS

339: -- Check number of response values.
340: begin
341: select count(1)
342: into respcnt
343: from WF_LOOKUPS
344: where LOOKUP_TYPE = format;
345: exception
346: when no_data_found then
347: return;

Line 488: from WF_LOOKUPS WL

484: meaning varchar2(80);
485: begin
486: select WL.MEANING
487: into meaning
488: from WF_LOOKUPS WL
489: where WL.LOOKUP_TYPE = GetLookupMeaning.ltype
490: and WL.LOOKUP_CODE = GetLookupMeaning.lcode;
491:
492: return(meaning);