APPS.AHL_DI_ASSO_DOC_ASO_PUB dependencies on FND_LOOKUP_VALUES_VL

Line 27: FROM FND_LOOKUP_VALUES_VL

23: BEGIN
24: IF (p_lookup_code IS NOT NULL) THEN
25: IF (p_check_id_flag = 'Y') THEN
26: SELECT lookup_code INTO x_lookup_code
27: FROM FND_LOOKUP_VALUES_VL
28: WHERE lookup_type = p_lookup_type
29: AND lookup_code = p_lookup_code
30: AND sysdate between start_date_active
31: AND nvl(end_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 meaning = p_meaning
40: AND sysdate between start_date_active
41: AND nvl(end_date_active,sysdate);