---

where o.approved is not null
    and o.deleted is null
    and t.effective_date <= $P{d2}
    and (
        ot.code <> 'TRANSFER_PENSION_TO_RESERVE'
        or da.owner_sharer_id
            is distinct from ca.owner_sharer_id
    )