OTL - Time card approval details stored in which table

Content

Hello Team,

 

i have requirement to pull the below mentioned details in Oracle time labor module for time card entered.

 

 

 

am able to get the person number, name and Time period, Total recorded hours from HWM_TM_REC_GRP_SUM_V. now problem is that from this table am not able to find link for HXT_APRV_TXN_DETAILS where this table has the links to soa work flow tables.

 

what is the intermediate table i should use to establish the link.

 

and do we have any table to know about additional status details like payroll processing.

 

Regards,

M Vijayalakshm