APPS.AHL_LTP_SPACE_CAPB_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 52: FROM FND_LOOKUP_VALUES_VL

48: --
49: IF (p_lookup_code IS NOT NULL) THEN
50: IF (p_check_id_flag = 'Y') THEN
51: SELECT lookup_code INTO x_lookup_code
52: FROM FND_LOOKUP_VALUES_VL
53: WHERE lookup_type = p_lookup_type
54: AND lookup_code = p_lookup_code
55: AND SYSDATE BETWEEN start_date_active
56: AND NVL(end_date_active,SYSDATE);

Line 62: FROM FND_LOOKUP_VALUES_VL

58: x_lookup_code := p_lookup_code;
59: END IF;
60: ELSE
61: SELECT lookup_code INTO x_lookup_code
62: FROM FND_LOOKUP_VALUES_VL
63: WHERE lookup_type = p_lookup_type
64: AND meaning = p_meaning
65: AND SYSDATE BETWEEN start_date_active
66: AND NVL(end_date_active,SYSDATE);