The scattering of small bodies in planetary systems: constraints on the possible orbits of cometary material