113: l_meaning VARCHAR2(80);
114: BEGIN
115: select MEANING
116: into l_meaning
117: from FA_LOOKUPS
118: where LOOKUP_TYPE = 'GAINLOSS'
119: and LOOKUP_CODE = 'GAIN';
120: return (l_meaning);
121: EXCEPTION
129: l_meaning VARCHAR2(80);
130: BEGIN
131: select MEANING
132: into l_meaning
133: from FA_LOOKUPS
134: where LOOKUP_TYPE = 'GAINLOSS'
135: and LOOKUP_CODE = 'LOSS';
136: return (l_meaning);
137: EXCEPTION