APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 304: FROM FND_LOOKUP_VALUES_VL

300: --
301: IF (p_lookup_code IS NOT NULL) THEN
302: IF (p_check_id_flag = 'Y') THEN
303: SELECT lookup_code INTO x_lookup_code
304: FROM FND_LOOKUP_VALUES_VL
305: WHERE lookup_type = p_lookup_type
306: AND lookup_code = p_lookup_code
307: AND SYSDATE BETWEEN start_date_active
308: AND NVL(end_date_active,SYSDATE);

Line 315: FROM FND_LOOKUP_VALUES_VL

311: END IF;
312: ELSE
313: --
314: SELECT lookup_code INTO x_lookup_code
315: FROM FND_LOOKUP_VALUES_VL
316: WHERE lookup_type = p_lookup_type
317: AND meaning = p_meaning
318: AND SYSDATE BETWEEN start_date_active
319: AND NVL(end_date_active,SYSDATE);