---

UPDATE report.fns_reference_request_journal fns
SET model_file_to_verification_id = (
    SELECT mf.id
    FROM dev.model_file_to_verification mf
    WHERE mf.service_name = 'SMEF FNS'
      AND mf.register_id = :rj_id
)
WHERE fns.smevregisterid = :rj_id;