USP_DATALIST_CRM_BBPAY_TEMPLATE_BYPAGE

CREATE procedure dbo.USP_DATALIST_CRM_BBPAY_TEMPLATE_BYPAGE(
    @SITECONTENTID integer = null,
    @SITEPAGEID integer = null,
    @DELIVERYCHANNELID uniqueidentifier = null
)
as
set nocount on;

select
    BBET.[ID]
from
    dbo.CRMBBPAYTEMPLATE 
    inner join dbo.BBPAYENVIRONMENTTEMPLATE BBET on CRMBBPAYTEMPLATE.ID = BBET.TEMPLATEID 
    inner join dbo.CRMBBENVIRONMENT E on E.ID = BBET.ENVIRONMENTID
where 
    SITEPAGEID = @SITEPAGEID
    and SITECONTENTID = @SITECONTENTID
    and coalesce(DELIVERYCHANNELID, '23B56292-0F3C-43AC-AF13-7767AD9D4057') = coalesce(@DELIVERYCHANNELID, '23B56292-0F3C-43AC-AF13-7767AD9D4057')
    and E.ISACTIVE = 1