How to use audit tables in my custom report query

Summary

How to use audit tables in my custom report query

Content

Hi,

I have a requirement to get the start date and complete date of my custom BI Publisher report and use that dates in the same report query.

Let us assume my datamodel name is ABC.xdo

I want to use below type of query in the same data model in ApplicationDB_HCM.

select *
from per_all_people_f
where last_update_date > (select max(report_end_date)
                                        from fusion_iau_viewer.bipublisher_v
                                         where report_name = 'ABC.xdo')

Can i use the audit table like this?

Any help in this regard will be appreciated.