UFN_GLFISCALYEAR_PERIODSHAVEACTIVITY

CREATE function UFN_GLFISCALYEAR_PERIODSHAVEACTIVITY(@PERIODXML XML)
returns bit as
begin
declare @RESULT bit
set @RESULT = 0

if exists( 
    select * 
    from FINANCIALTRANSACTIONLINEITEM LI
    inner join dbo.JOURNALENTRY JE on JE.FINANCIALTRANSACTIONLINEITEMID = LI.ID
    inner join (select T2.STARTDATE, T2.ENDDATE 
        from GLFISCALPERIOD T2
        left join dbo.UFN_GLFISCALYEAR_PERIODS_FROMITEMLISTXML(@PERIODXML) T1 On T1.STARTDATE = T2.STARTDATE and T1.ENDDATE = T2.ENDDATE
        where T1.STARTDATE is null
            and (T2.STARTDATE >= (select top 1 STARTDATE from dbo.UFN_GLFISCALYEAR_PERIODS_FROMITEMLISTXML(@PERIODXML) order by SEQUENCE asc))
            and (T2.ENDDATE <= (select top 1 ENDDATE from dbo.UFN_GLFISCALYEAR_PERIODS_FROMITEMLISTXML(@PERIODXML) order by SEQUENCE desc))
    ) V1 On cast(LI.POSTDATE as datetime) between V1.STARTDATE and V1.ENDDATE )
        set @RESULT = 1;

RETURN @RESULT

end