Sample SQL to List Tax Periods

You can use this SQL to list the pay periods and related tax periods for a particular tax year.

select
 ptp.TIME_PERIOD_ID
,ptp.PAYROLL_ID
,ptp.PERIOD_NAME
,ptp.PERIOD_NUM
,ptp.PERIOD_TYPE
,ptp.START_DATE
,ptp.END_DATE
,ptp.DEFAULT_PAYDATE
,ptp.REGULAR_PROCESS_DATE
,ptp.REGULAR_EARN_DATE
,ptp.CUT_OFF_DATE
,DECODE(NVL(ptp.PERIOD_CATEGORY,'E'),'E','Earning','S','Statutory') PERIOD_CATEGORY
from
pay_all_payrolls_f pap,
pay_time_periods ptp
where
pap.payroll_name = 'JL Monthly'
and pap.payroll_id = ptp.payroll_id 
and period_name like '%2022%'
order by period_name, start_date;