Joining Batch Process table with Time Tables

Summary

I need help with joining the tables associated with Batch Processes and Time Details.

Content

Hi All,

 

I have a requirement to get the Time Load Batch Id for a time card.

I am using the following tables to find the BATCH PROCESSES - 

HWM_BATCH_OBJECTS;
HWM_BATCH_PROCESSES;
HWM_BATCH_PROC_INSTANCES;

Can we join it with Time Card details that are present in the below tables - 

HWM_TM_REC

HWM_TM_REC_GRP

 

Please let me know if somebody has achieved this before.