SELECT
ed.account_dt,
ed.account_ct,
COALESCE(ed.pension_scheme_id, et.pens_schema_dt)
AS debit_scheme_id,
COALESCE(ed.pension_scheme_id, et.pens_schema_ct)
AS credit_scheme_id,
et.contract_class_code
FROM back_office.eps_transaction_source src
JOIN back_office.eps_transaction et
ON et.eps_transaction_source_id = src.id
JOIN ourpension.eps e
ON e.id = et.eps_id
JOIN ourpension.eps_detail ed
ON ed.eps_id = e.id
WHERE src.operation_id = 84061424
AND e.service_type = 'NPO';