---

select
    pppp.param_pl_id,
    pp.name,
    pp.brief,
    pppp.value_ref,
    prod_line.get_value_link_param(
        cast(pp.id as integer),
        cast(pppp.value_ref as integer)
    ) as param_value
from prod_line.pens_product_param_pl pppp
join prod_line.param_pl pp
    on pp.id = pppp.param_pl_id
where pppp.pens_product_id = 8977
  and pp.brief = 'ПериодГарантВосполнения';