Intermediate table that will give the link between Assignment and Payroll Relationship

Summary:

Need the tables that can be used to set up link between per_all_assignments_m(assignment) and Payroll Relationship (pay_pay_relationships_dn)

Content (required):

We have a Scenario in our project where Payroll Relationship number is same for two assignments of an employee and when payroll processes are run like calculate payroll, prepayment archive etc. , we can see the processes in person results for both assignments even though if only latest assignments is considered while running and in payroll reports we are able to see two records as we are using payroll relationship as the key.

Need all the tables that will give the link between assignment and Payroll Relationship