APPS.AHL_DI_ASSO_DOC_GEN_PUB dependencies on FND_LOOKUP_VALUES_VL

Line 422: FROM FND_LOOKUP_VALUES_VL

418: BEGIN
419: IF (p_lookup_code IS NOT NULL) THEN
420: IF (p_check_id_flag = 'Y') THEN
421: SELECT lookup_code INTO x_lookup_code
422: FROM FND_LOOKUP_VALUES_VL
423: WHERE lookup_type = p_lookup_type
424: AND lookup_code = p_lookup_code
425: AND sysdate between start_date_active
426: AND nvl(end_date_active,sysdate);

Line 432: FROM FND_LOOKUP_VALUES_VL

428: x_lookup_code := p_lookup_code;
429: END IF;
430: ELSE
431: SELECT lookup_code INTO x_lookup_code
432: FROM FND_LOOKUP_VALUES_VL
433: WHERE lookup_type = p_lookup_type
434: AND meaning = p_meaning
435: AND sysdate between start_date_active
436: AND nvl(end_date_active,sysdate);