---

report.fns_reference_request_journal fj

left join dev.model_file_to_verification mfc 
    on mfc.id = fj.model_file_to_verification_id

left join report.smev_register sr 
    on sr.id = mfc.register_id

left join ourpension.contract contract 
    on contract.number = fj.contract_number

left join ourpension.individual i 
    on i.id = contract.individual_id

left join ourpension.entity e 
    on e.id = contract.entity_id



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
)