USP_PREVIOUSFISCALYEAR

            create procedure dbo.USP_PREVIOUSFISCALYEAR
            (
                @FISCALYEARSTARTDATE date output,
                @FISCALYEARENDDATE date output
            )
            as
            begin
                select
                    @FISCALYEARSTARTDATE = min(FP2.STARTDATE),
                    @FISCALYEARENDDATE = max(FP2.ENDDATE)
                from dbo.GLFISCALPERIOD
                    inner join dbo.GLFISCALYEAR on GLFISCALPERIOD.GLFISCALYEARID = GLFISCALYEAR.ID
                    inner join dbo.GLFISCALYEAR as FY2 on GLFISCALYEAR.YEARSEQUENCE-1 = FY2.YEARSEQUENCE
                    inner join dbo.GLFISCALPERIOD as FP2 on FY2.ID = FP2.GLFISCALYEARID
                where getdate() between GLFISCALPERIOD.STARTDATE and GLFISCALPERIOD.ENDDATE;
            end