---

sr.number = :sr_number

and exists (
    select 1
    from ourpension.application_termination_contract atc
    left join ourpension.application_termination_contract_data atcd 
        on atcd.application_termination_contract_id = atc.id
    left join ourpension.sharer sh 
        on sh.id = atcd.sharer_id
    where atc.individual_id = i.id
      and sh.contract_id = contract.id
)