Missing a voided check in report

Summary:

Missing a void check in pay_ce_transations

Content (please ensure you mask any confidential information):

Hi,
One of our report to fetch a list of voided checks as on effective date is using pay_ce_transactions table along with few other tables. But there is one check that was voided but not in pay_ce_transactions table. Below is the query that I am using:

SELECT DISTINCT
papf.person_number,
ppnf.DISPLAY_NAME person_name,
pprd.PAYROLL_RELATIONSHIP_NUMBER,
tcm.PAYMENT_TYPE_NAME payment_type,
tcm.CHECK_NUMBER Payment_Reference,
tcm.amount||' '||tcm.CURRENCY_CODE payment_amount,