SELECT
papf.payroll_name,
papf.period_type,
pcs.consolidation_set_name,
ptp.period_name,
to_char(ptp.start_date, ‘YYYY/MM/DD’) start_date,
to_char(ptp.end_date, ‘YYYY/MM/DD’) end_date,
to_char(ptp.cut_off_date, ‘YYYY/MM/DD’) cut_off_date,
to_char(ptp.regular_earn_date, ‘YYYY/MM/DD’) date_earned,
to_char(ptp.regular_process_date, ‘YYYY/MM/DD’) payroll_run_date,
to_char(ptp.default_paydate, ‘YYYY/MM/DD’) date_paid
FROM
pay_all_payrolls_f papf,
pay_time_periods ptp,
pay_consolidation_sets pcs
WHERE
papf.payroll_id = ptp.payroll_id
AND trunc(sysdate) BETWEEN papf.effective_start_date AND papf.effective_end_date
AND papf.consolidation_set_id = pcs.consolidation_set_id
AND ptp.cut_off_date IS NOT NULL
ORDER BY
papf.payroll_name,
ptp.start_date

Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search