SELECT
papf.payroll_name,
--papf.period_type,
ptp.period_name,
to_char(ptp.start_date, 'YYYY/MM/DD') start_date,
to_char(ptp.end_date, 'YYYY/MM/DD') end_date
FROM
PAY_ALL_PAYROLLS_F papf,
PAY_TIME_PERIODS ptp
WHERE
papf.payroll_id = ptp.payroll_id
AND trunc(sysdate) BETWEEN papf.effective_start_date AND papf.effective_end_date
AND TO_CHAR(ptp.start_date,'YYYY') = :P_EFFECTIVE_DATE
AND TO_CHAR(ptp.start_date,'MM/DD') > '06/01'
AND ROWNUM < 2
ORDER BY to_char(ptp.start_date, 'YYYY/MM/DD')Related Posts
