select * from v_personstate where person_id in (select person_id from persis.v_staff where lpuunit_id not in (select lpuunit_id from v_lpuunit))
