---

SELECT
    f.sharer_id,
    f.prod_line_pens_scheme_id,
    f.number AS pension_scheme,
    ps.index_scheme,
    ps.uid_1c
FROM actuary.get_pension_scheme(
    ARRAY[14423113]::integer[],
    NULL::integer[],
    DATE '2026-10-01',
    'NPO'::text
) f
LEFT JOIN prod_line.pens_scheme ps
    ON ps.id = f.prod_line_pens_scheme_id;




SELECT
    h.strategy_id,
    s.name AS strategy,
    h.begin_date,
    h.end_date
FROM ourpension.invest_strategy_history_sharer h
LEFT JOIN prod_line.hb_invest_strategy s
    ON s.id = h.strategy_id
WHERE h.sharer_id = 14423113
ORDER BY h.begin_date DESC;