---

select
    form_date,
    to_char(
        to_date(my_report, 'MM.YYYY') + interval '1 month - 1 day',
        'DD.MM.YYYY'
    ) as enddate,
    (
        select concat_ws(' ', a.last_name, a.first_name, a.middle_name)
        from ourpension.agent a
        where a.id = cast(nullif($P{executorAgentIdPU}, '') as bigint)
    ) as executor_fio_pu,
    (
        select concat_ws(' ', a.last_name, a.first_name, a.middle_name)
        from ourpension.agent a
        where a.id = cast(nullif($P{executorAgentIdBU}, '') as bigint)
    ) as executor_fio_bu
from back_office.report_conformity_pu_bu
where id = $P{id}