APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on FND_LOOKUP_VALUES_VL

Line 29: FROM FND_LOOKUP_VALUES_VL

25: BEGIN
26: IF (p_lookup_code IS NOT NULL) THEN
27: IF (p_check_id_flag = 'Y') THEN
28: SELECT lookup_code INTO x_lookup_code
29: FROM FND_LOOKUP_VALUES_VL
30: WHERE lookup_type = p_lookup_type
31: AND lookup_code = p_lookup_code
32: AND sysdate between start_date_active
33: AND nvl(end_date_active,sysdate);

Line 39: FROM FND_LOOKUP_VALUES_VL

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