how to get pay_payroll_actions.date_earned?

I have a working report with the following query, and now need to add  payroll date_earned.

The issue is that when I added the code in green, the query hangs even for a single employee number, and won't finish after ten minutes. It previously took only few seconds.

Is there any other table I could use to get this date_earned information?

select a1.action_information18  gre,

       a1.action_information15  org,

       l.location_code          loc,

       p.employee_number        emp_num,

       a1.action_information1   full_name,

       a.action_information18   pay_method,

       a.action_information16   net_pay,

       decode(a.action_information6,'C','Checking Account',