50: seq in varchar2)
51: as
52: cursor lookup_codes(p_lookup_type varchar2) is
53: select MEANING, LOOKUP_CODE
54: from WF_LOOKUPS
55: where LOOKUP_TYPE = p_lookup_type
56: order by MEANING;
57:
58: template varchar2(4000);
268: is
269: meaning varchar2(80);
270: cursor lov_lookup is
271: select WL.MEANING
272: from WF_LOOKUPS WL
273: where WL.LOOKUP_TYPE = GetLookupMeaning.ltype
274: and WL.LOOKUP_CODE = GetLookupMeaning.lcode;
275:
276: begin