---

insert into back_office.report_conformity_pu_bu_detail (
    report_conformity_pu_bu_id,
    account,
    pension_scheme_id,
    strategy_id,
    contract_class_code,
    uidpensionscheme,
    sum_dt_pu,
    sum_ct_pu
)
select
    currval('back_office.report_conformity_pu_bu_id_seq'),
    g.acc,
    g.pension_scheme_id,
    g.strategy_id,
    g.contract_class_code,
    cast(ps.uid_1c as varchar),
    g.sum_dt,
    g.sum_ct
from (
    select
        acc,
        pension_scheme_id,
        strategy_id,
        contract_class_code,
        sum(sum_dt) as sum_dt,
        sum(sum_ct) as sum_ct
    from temp_sum
    group by
        acc,
        pension_scheme_id,
        strategy_id,
        contract_class_code
) g
left join prod_line.pens_scheme ps
    on ps.id = g.pension_scheme_id;