---

where (
    nullif(:plannedTransferDate, '') is null
    or cd.planned_transfer_date = to_date(nullif(:plannedTransferDate, ''), 'DD.MM.YYYY')
)