Payroll Run Results and Prepayment details in one payroll interface extract

Summary

Payroll Run Results and Prepayment details in one payroll interface extract

Content

We have a requirement where we need to send the run results and prepayment details to a third party in the same extract. We have identified the UEs that are required and are struggling to find a join between the run results and prepayments UE. Can someone please help us how we can get the prepayment details for a given payroll_rel_action_id?

PER_EXT_PAY_EMPLOYEES_UE
|-->PAY_INTERFACE_PAYROLL_REL_UE (linked via Payroll Relationship ID)
|-->PAY_EXTRACT_RUN_RESULT_VALUES_UE (linked via Payroll Relationship Action ID)