I think the generated SQL should be:
delete from USER_SYSTEM where (USER_ID) in (select person_userid from PROPREF_PERS)