How to Join FND_BPM_TASK_HISTORY_B with HCM Tables to Retrieve Employee Conversion Date

Summary:

Hi Everyone,

I have an existing Oracle HCM report that retrieves employee Hire and Rehire information.

There is now an additional requirement to include the Employee Conversion Date, which is defined as the date when HR initiated the conversion transaction and it was subsequently approved. Based on my understanding, this information is available through the Transaction Console.

I am trying to determine how to retrieve this data from the FND_BPM_TASK_HISTORY_B table and link it to the employee records.

My questions are:

1. How can I join FND_BPM_TASK_HISTORY_B with either PER_ALL_ASSIGNMENTS_M