SQL Reporting Transactions

Hi I need to check a Approved documents of records transactions. But I couldnt Get The Transaction Id which matches with my Document_Code from Hrc_Txn_Header and Hrc_Txn_Data How Can I Get this ID on sql and match with my document code from HR_DOCUMENTS_OF_RECORD HDR

(SELECT txnh.subject_id,

               txnd.COMPLETED_DATE     APPROVED_DATE,

               txnh.PROCESS_ID,

               txnh.OBJECT_ID,

               txnh.Transaction_Id

          FROM (SELECT *

                  FROM Fusion.Hrc_Txn_Header txn

                 WHERE transaction_id =

                       (SELECT MAX (txne.transaction_id)

                          FROM Fusion.Hrc_Txn_Header txne

                         WHERE txn.OBJECT_ID = txne.OBJECT_ID)) Txnh,