Compensation Worksheet Approval transactions tables related issues

Summary:

Users are trying to extract the data related to Compensation worksheet approval, But we are not getting right result. Getting the same result for different transactions. We need to understand the gap and observed that approval transaction related employees data issue.
To meet our requirement, we are using the below tables.

cmp_plans_tl cpt,
cmp_plan_periods cpp,
cmp_cwb_person_info ccpi,
cmp_transactions ct,
hrc_txn_header hth,
hrc_txn_data htd,
fa_fusion_soainfra.wftaskhistory wft,
per_all_people_f papf,
per_all_assignments_m paam

here, we need to know what is the link between cmp_transactions and cmp_cwb_person_info to get the