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