How to create a report for various payroll runs

SELECT < Columns>
from pay_payroll_actions ppa,
pay_all_payrolls_f papf,
per_time_periods ptp
where papf.payroll_id = ppa.payroll_id
and ppa.effective_date between papf.effective_start_date and papf.effective_end_date
and ppa.action_type IN ('Q','R')
and ptp.payroll_id = papf.payroll_id
and papf.payroll_name = :pPayrollName
and ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date
and :pDate BETWEEN ptp.start_date AND ptp.end_date

Pass Any Date and Payroll Name. The query should list down all payroll runs in the period in which the date falls.