APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 45: FROM FND_LOOKUP_VALUES_VL

41: --
42: IF (p_lookup_code IS NOT NULL) THEN
43: IF (p_check_id_flag = 'Y') THEN
44: SELECT lookup_code INTO x_lookup_code
45: FROM FND_LOOKUP_VALUES_VL
46: WHERE lookup_type = p_lookup_type
47: AND lookup_code = p_lookup_code
48: AND SYSDATE BETWEEN start_date_active
49: AND NVL(end_date_active,SYSDATE);

Line 56: FROM FND_LOOKUP_VALUES_VL

52: END IF;
53: ELSE
54: --
55: SELECT lookup_code INTO x_lookup_code
56: FROM FND_LOOKUP_VALUES_VL
57: WHERE lookup_type = p_lookup_type
58: AND meaning = p_meaning
59: AND SYSDATE BETWEEN start_date_active
60: AND NVL(end_date_active,SYSDATE);