---

select
    vst.code,
    vst.label,
    vst.is_payment_source
from ourpension.voc_sharer_types vst
where vst.is_payment_source = true
order by vst.label;






select
    cp.contract_id,
    cp.payment_source_code,
    vst.label as payment_source
from ourpension.contract_params cp
left join ourpension.voc_sharer_types vst
    on vst.code = cp.payment_source_code
where cp.payment_source_code is not null
order by cp.contract_id desc
limit 20;