149: l_meaning VARCHAR2(80);
150: BEGIN
151: select MEANING
152: into l_meaning
153: from FA_LOOKUPS
154: where LOOKUP_TYPE = 'GAINLOSS'
155: and LOOKUP_CODE = 'GAIN';
156: return (l_meaning);
157: EXCEPTION
165: l_meaning VARCHAR2(80);
166: BEGIN
167: select MEANING
168: into l_meaning
169: from FA_LOOKUPS
170: where LOOKUP_TYPE = 'GAINLOSS'
171: and LOOKUP_CODE = 'LOSS';
172: return (l_meaning);
173: EXCEPTION