[Home] [Help]
7: FUNCTION GET_LOOKUP_MEANING(p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2) RETURN VARCHAR2 AS
8: l_meaning FND_LOOKUPS.MEANING%TYPE;
9: BEGIN
10: SELECT MEANING INTO l_meaning
11: FROM FND_LOOKUP_VALUES
12: WHERE LOOKUP_TYPE = p_lookup_type
13: AND LOOKUP_CODE = p_lookup_code
14: AND LANGUAGE = USERENV('LANG')
15: AND VIEW_APPLICATION_ID = 0