= $P{startDate}
AND acts.activity_start_time <= date_add($P{endDate}, INTERVAL "23:59:59" HOUR_SECOND)
AND (Status = "POSTED")
AND (participations.arch_short_name = "participation.customer")
AND ((acts.arch_short_name = "act.customerAccountPayment")
OR (acts.arch_short_name = "act.customerAccountRefund")
)
ORDER BY
acts.activity_start_time ASC]]>