UFN_CMS_BBPAYTEMPLATE_GETTEMPLATEBYPAGE

create function dbo.[UFN_CMS_BBPAYTEMPLATE_GETTEMPLATEBYPAGE](@SITEPAGEID as Integer) 
returns uniqueidentifier 
with execute as caller
as
                begin
                    declare @retID uniqueidentifier;

                    select top 1
                        @retID = CRMBBPAYTEMPLATE.[ID]
                    from
                        dbo.CRMBBPAYTEMPLATE
                    where 
                        SITEPAGEID = @SITEPAGEID

                    return @retID;
                end