APPS.AHL_DI_DOC_REVISION_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 sysdate between start_date_active
30: AND nvl(end_date_active,sysdate);

Line 36: FROM FND_LOOKUP_VALUES_VL

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