APPS.AHL_OSP_SHIPMENT_PUB dependencies on FND_LOOKUP_VALUES_VL

Line 160: FROM fnd_lookup_values_vl

156: x_return_val OUT NOCOPY BOOLEAN) IS
157:
158: CURSOR fnd_lookup_csr (p_lookup_type IN VARCHAR2, p_lookup_meaning IN VARCHAR2) IS
159: SELECT lookup_code
160: FROM fnd_lookup_values_vl
161: WHERE lookup_type = p_lookup_type
162: AND meaning = p_lookup_meaning
163: AND TRUNC(SYSDATE) >= TRUNC(NVL(start_date_active, SYSDATE))
164: AND TRUNC(SYSDATE) < TRUNC(NVL(end_date_active, SYSDATE+1));