Court Order reference number from payroll run results

Hi

We are trying to get the Court Order reference number from the Payroll run results table, but this is inconsistent with some records where for some it fetches the exact record but for some it doesn't and returns blank even they had reference number.

Can anyone help what should be the exact link between PAY_DIR_COMP_DETAILS_F & PAY_RUN_RESULTS table to get the correct order reference number.

Thanks & Regards

Prasanna