Загрузка данных

,
(
    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