UFN_PDACCOUNTCODEMAPPING_SETUP

CREATE function dbo.UFN_PDACCOUNTCODEMAPPING_SETUP()
returns bit
            with execute as caller
            as begin

            declare @SETUPCOMPLETE bit;


            if exists(
                select v1.ID from 
                (    select t1.ID
                    from
                        dbo.PDACCOUNTCODEMAPPING T1
                        join PDACCOUNTSEGMENTVALUE T2 on T1.DEBITPDACCOUNTSEGMENTVALUEID = T2.ID or T1.CREDITPDACCOUNTSEGMENTVALUEID = T2.ID
                        join dbo.PDACCOUNTSTRUCTURE T3 on T2.PDACCOUNTSTRUCTUREID = T3.ID
                        where T3.PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B' 
                union all    
                    select t1.ID
                    from
                        dbo.PDACCOUNTCODEMAPPING T1
                        join GLACCOUNT T2 on T1.CREDITGLACCOUNTID = T2.ID or T1.DEBITGLACCOUNTID = T2.ID
                        where T2.PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'
                )V1                

            )
                set @SETUPCOMPLETE = 1
            else
                set @SETUPCOMPLETE = 0

            return @SETUPCOMPLETE;
        end