View leave notification history

Hi,
I have a requirement to view the leave notification history of a leave request to the approver. This includes viewing whether the leave was APPROVED or REJECTED or REQUESTed FOR MORE INFO.

I am able to view the history of leave notification until the are APPROVED or REJECTED, etc by the approver using the following query, which makes use of the hr_api_transactions table. But after the leave has been approved or rejected, the data will be removed from the table. Is there a way to retrieve this data for leaves with all statuses? Thanks in advance.

SELECT *
FROM
  (SELECT C.SEQUENCE SEQUENCE_NO,
          C.NOTIFICATION_ID ,
          IAS.ITEM_KEY,
          C.FROM_ROLE ,
          C.FROM_USER ,
          C.TO_ROLE ,
          C.TO_USER ,
          WF_CORE.TRANSLATE(C.ACTION) ACTION,
          C.USER_COMMENT ,