unable to query the rejected transaction details from the approval related tables

Summary:

We have a requirement to report on the approval transactions (approved/rejected) and we have built the query based on hrc_txn_fnd_bpm_task_vl and hcm_fusion_soainfra tables.. We can only see the data in hcm_fusion_soainfra tables. For approved transactions it is working fine, however for the rejected txns, the data is not present in hrc_txn_fnd_bpm_task_vl tables.. also there is an archive process which will be scheduled, does any one have idea of the archive tables in fusion and can we report on those tables. And will we get both approved and rejected transactions from those archive tables?