APPS.AHL_DI_DOC_INDEX_PUB dependencies on FND_LOOKUP_VALUES_VL

Line 26: FROM FND_LOOKUP_VALUES_VL

22: BEGIN
23: IF (p_lookup_code IS NOT NULL) THEN
24: IF (p_check_id_flag = 'Y') THEN
25: SELECT lookup_code INTO x_lookup_code
26: FROM FND_LOOKUP_VALUES_VL
27: WHERE lookup_type = p_lookup_type
28: AND lookup_code = p_lookup_code
29: AND ENABLED_FLAG= 'Y'
30: AND sysdate between nvl(start_date_active,sysdate)

Line 37: FROM FND_LOOKUP_VALUES_VL

33: x_lookup_code := p_lookup_code;
34: END IF;
35: ELSE
36: SELECT lookup_code INTO x_lookup_code
37: FROM FND_LOOKUP_VALUES_VL
38: WHERE lookup_type = p_lookup_type
39: AND upper(meaning) = upper(p_meaning)
40: AND ENABLED_FLAG= 'Y'
41: AND sysdate between nvl(start_date_active,sysdate)