UFN_CMS_BBPAYTEMPLATE_GETTEMPLATEBYPAGEDELIVERYCHANNEL

CREATE function dbo.[UFN_CMS_BBPAYTEMPLATE_GETTEMPLATEBYPAGEDELIVERYCHANNEL](@SITEPAGEID as Integer, @DELIVERYCHANNELID as uniqueidentifier) 
returns uniqueidentifier 
with execute as caller
as
                begin
                    declare @retID uniqueidentifier;

          select top 1 
            @retID = BPT.ID 
          from 
            dbo.BBPAYENVIRONMENTTEMPLATE as BPT 
            inner join dbo.CRMBBPAYTEMPLATE CBPT on CBPT.ID = BPT.TEMPLATEID
            inner join dbo.CRMBBENVIRONMENT E on E.ID = BPT.ENVIRONMENTID and E.ISACTIVE = 1
          where 
            CBPT.SITEPAGEID = @SITEPAGEID 
            and CBPT.DELIVERYCHANNELID = @DELIVERYCHANNELID

                    return @retID;
                end