---

(
    SELECT hp.name
    FROM prod_line.pens_product_param_pl p_i

    JOIN prod_line.param_pl def_i
        ON def_i.id = p_i.param_pl_id

    JOIN prod_line.table_param_pl_invest_profile ip
        ON ip.pens_product_param_pl_id = p_i.id

    JOIN prod_line.hb_invest_profile hp
        ON hp.id = ip.hb_invest_profile_id

    WHERE p_i.pens_product_id = pp.id
      AND def_i.brief = 'ИнвестПрофиль'
      AND (
          ip.validity_period_from IS NULL
          OR CURRENT_DATE >= ip.validity_period_from
      )
      AND (
          ip.validity_period_to IS NULL
          OR CURRENT_DATE <= ip.validity_period_to
      )

    ORDER BY ip.validity_period_from DESC NULLS LAST
    LIMIT 1
) AS invest_profile_name,