300: ELSE
301: /*modified the following query for bug no.3876060 */
302: select T.MEANING
303: into l_meaning
304: from FA_LOOKUPS_TL T
305: where T.LANGUAGE = USERENV('LANG')
306: and T.LOOKUP_TYPE = X_lookup_type
307: and T.LOOKUP_CODE = X_lookup_code;
308:
343: ELSE
344: /* modified the following query for bug no.3876060 */
345: SELECT T.LOOKUP_CODE
346: into l_lookup_code
347: FROM FA_LOOKUPS_TL T
348: WHERE T.LANGUAGE = USERENV('LANG')
349: AND T.LOOKUP_TYPE = X_lookup_type
350: AND T.MEANING = X_meaning;
351: