The following query will show people who are not tied to the following tables: Pledges, Payments, Sponsors, and Agencies.
select *
from
camnamesv na,
camsponsors sp,
campledges pl,
campayments pa,
camagencies ag
where
na.nameid = sp.nameid (+) and sp.nameid is null
and na.nameid = pl.nameid (+) and pl.nameid is null
and na.nameid = pa.nameid (+) and pa.nameid is null
and na.nameid = ag.nameid (+) and ag.nameid is null