UFN_PDACCOUNTSEGMENTMAP_SETUP2

create function dbo.UFN_PDACCOUNTSEGMENTMAP_SETUP2
(
    @ID uniqueidentifier
)
        returns bit
            with execute as caller
            as begin
            declare @REGULARSETUPCOMPLETE bit;
            declare @COMPOSITESETUPCOMPLETE bit;
            declare @SETUPCOMPLETE bit = 0;
            if exists(select * from PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @ID and  SEGMENTTYPE = 3)  
                begin
                    if exists(
                        select
                            T1.ID
                        from
                            dbo.PDACCOUNTSEGMENTMAPPING T1
                            join dbo.PDACCOUNTSTRUCTURE T2 on T1.PDACCOUNTSTRUCTUREID = T2.ID
                        where
                            (T1.ISDEFAULT = 1) and (T1.PDACCOUNTSEGMENTVALUEID is null)
                            and (T2.PDACCOUNTSYSTEMID = @ID)
                    )
                        set @REGULARSETUPCOMPLETE = 0
                    else if exists(
                        select
                            T1.ID
                        from
                            dbo.PDACCOUNTSEGMENTMAPPING T1
                            join dbo.PDACCOUNTSTRUCTURE T2 on T1.PDACCOUNTSTRUCTUREID = T2.ID
                        where
                            (T2.PDACCOUNTSYSTEMID = @ID)
                    )
                        set @REGULARSETUPCOMPLETE = 1
                    else
                        set @REGULARSETUPCOMPLETE = 0
                end
            else 
                set @REGULARSETUPCOMPLETE = 1

            if exists(select * from PDACCOUNTSTRUCTURE where SEGMENTTYPE = 4 and PDACCOUNTSYSTEMID = @ID)  
                begin
                    if exists(select T1.ID from dbo.PDCOMPOSITESEGMENTMAPPING T1 
                                join dbo.PDACCOUNTSTRUCTURE T2 on T1.PDACCOUNTSTRUCTUREID = T2.ID
                                where T2.PDACCOUNTSYSTEMID = @ID)
                        set @COMPOSITESETUPCOMPLETE = 1
                    else
                        set @COMPOSITESETUPCOMPLETE = 0
                end
            else 
                set @COMPOSITESETUPCOMPLETE = 1                



            if @REGULARSETUPCOMPLETE = 1 and @COMPOSITESETUPCOMPLETE = 1 
                set @SETUPCOMPLETE = 1

            return @SETUPCOMPLETE;
        end