APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT dependencies on AR_LOOKUPS

Line 422: FROM ar_lookups

418: IF p_geo_structure_rec.parent_geography_type = 'COUNTRY' then
419: BEGIN
420: SELECT lookup_code
421: INTO l_addr_val_level
422: FROM ar_lookups
423: WHERE lookup_type = 'HZ_ADDRESS_VALIDATION_LEVEL'
424: AND lookup_code = p_geo_structure_rec.addr_val_level;
425: EXCEPTION WHEN NO_DATA_FOUND THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;