Looking for DBI to fetch Payroll Action ID triggered from Evaluate Late Hire

Summary:

Recently we had added creation of Temporary Assignment to 'Evaluate Late Hire' event so that any late Temporary assignment creation can be processed correctly. However, during retro processing we found that in some cases element was processed twice, To Avoid this we wanted to skip the element entry created from 'Evaluate Late Hire' for some cases.

To identify the source flow, we tried using the following query:

SELECT 'Y'
FROM pay_entry_proc_details eproc,
pay_payroll_rel_actions ret_pra,
pay_payroll_actions ret_ppa,
pay_pay_relationships_dn pre,
pay_payroll_rel_actions orig_run_pra,
pay_payroll_actions orig_run_ppa,