APPS.ZX_UTIL_PKG dependencies on FND_LOOKUPS

Line 31: l_meaning fnd_lookups.meaning%TYPE;

27:
28: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
29: p_lookup_code IN VARCHAR2)
30: RETURN VARCHAR2 IS
31: l_meaning fnd_lookups.meaning%TYPE;
32: l_hash_value NUMBER;
33: BEGIN
34:
35: IF p_lookup_code IS NOT NULL AND

Line 47: FROM fnd_lookups

43: IF pg_zx_lookups_rec.EXISTS(l_hash_value) THEN
44: l_meaning := pg_zx_lookups_rec(l_hash_value);
45: ELSE
46: SELECT meaning INTO l_meaning
47: FROM fnd_lookups
48: WHERE lookup_type = p_lookup_type
49: AND lookup_code = p_lookup_code
50: AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE)
51: AND NVL(ENABLED_FLAG, 'N') = 'Y';