--Prior year begin and end date
    SELECT TO_DATE(EXTRACT(YEAR FROM SYSDATE)-1 || '-01' || '-01') AS Begin
        ,ROUND(SYSDATE, 'YEAR') -1 AS End
    
    FROM DUAL
;