---

select 1
where not exists (
    select 1
    from ourpension.load_snv l
    where l.file_id = :fileId
      and not exists (
          select 1
          from ourpension.contract ct
          where ct.number = l.contract_number
      )
)