UFN_SPROPPCHILD_VALID_ORPHANEDCODE_FOR_GROUP

            create function dbo.UFN_SPROPPCHILD_VALID_ORPHANEDCODE_FOR_GROUP
            (
                @ID uniqueidentifier,
                @ISPORPHANED tinyint
            )
              returns bit
              with execute as caller
              as begin
          declare @ORPHANVAL tinyint;

          select 
            @ORPHANVAL = SG.ISORPHANEDCODE
          from
            SPONSORSHIPOPPORTUNITY SO
            inner join SPONSORSHIPOPPORTUNITYGROUP SG on SO.SPONSORSHIPOPPORTUNITYGROUPID = SG.ID
          where
            SO.ID = @ID;

          /* 0 = Any on group or child isorphan = group isorphan. */
          if @ORPHANVAL = 0 or @ISPORPHANED = @ORPHANVAL OR (@ISPORPHANED = 0 AND @ORPHANVAL = 2)
                    return 1;

                return 0;
            end