Taleo retrieval guidance

Summary:

Hello Oracle Team,

We are currently on Oracle recruiting cloud but our previous system is Taleo. Post we went live, old Taleo data has been migrated into our in house database with same Taleo structure. We usually get data request from our business to share the offer letters of the employees from old Taleo and we use pull the data from migrated system.

While doing this we observed for few candidates the resume what we are getting is not matching with the candidate. Can you please verify below query and confirm if we are using right joins and tables from below query ? or do we have use add any other columns.