---

COALESCE(
    cp.min_payment_term,
    (
        SELECT pt_min.min_term_from
        FROM prod_line.pens_product_param_pl p_min

        JOIN prod_line.param_pl def_min
            ON def_min.id = p_min.param_pl_id

        JOIN prod_line.table_param_pl_payment_term pt_min
            ON pt_min.pens_product_param_pl_id = p_min.id

        WHERE p_min.pens_product_id = pp.id
          AND def_min.brief = 'СрокВыплаты'
          AND pt_min.min_term_from IS NOT NULL
          AND (
              pt_min.app_date_from IS NULL
              OR c.date >= pt_min.app_date_from
          )
          AND (
              pt_min.app_date_to IS NULL
              OR c.date <= pt_min.app_date_to
          )

        ORDER BY
            pt_min.app_date_from DESC NULLS LAST,
            pt_min.id DESC
        LIMIT 1
    )
) AS min_payment_term,