UFN_PROGRAM_ALLOWEDFORSALESMETHOD

            create function dbo.UFN_PROGRAM_ALLOWEDFORSALESMETHOD
            (
                @ID uniqueidentifier,
                @SALESMETHODTYPECODE tinyint
            )
            returns bit
            with execute as caller
            as begin
                if exists (
                    select
                        1
                    from
                        dbo.PROGRAMSALESMETHOD
                    inner join
                        dbo.SALESMETHOD on PROGRAMSALESMETHOD.SALESMETHODID = SALESMETHOD.ID
                    where
                        PROGRAMSALESMETHOD.PROGRAMID = @ID
                        and SALESMETHOD.TYPECODE = @SALESMETHODTYPECODE
                )
                    return 1;

                return 0;
            end