I need to get the updateddate of the workflow when it is approved submitted by employee

Summary:

I need to get the updateddate (FA_FUSION_SOAINFRA.WFTASK) of the workflow when it is submitted by employee in the manage document of records. I am using below query but not getting data.

I see the table link between the hr_documents_of_record and HRC_TXN_HEADER is not working. Can I get the correct link btw these two table?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT
substr(max(WFT.UPDATEDDATE),1,10)
FROM
hr_documents_of_record hdor,