UFN_CMS_BBPAYTEMPLATEUPLOAD_LOOKAHEAD

CREATE function dbo.UFN_CMS_BBPAYTEMPLATEUPLOAD_LOOKAHEAD (
    @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null
)
returns bit
with execute as caller
as begin

    declare @SHOULDRUN bit = 0;

    select
        @SHOULDRUN = 1
    where 
        not exists(select ID from dbo.Setting where ID = 127 and Value = 'False')   -- check BBSPTemplatesAndUploadEnabled

        and exists(select SITECONTENTID from dbo.UFN_CMS_BBPAY_CONTENTNEEDINGUPDATE_DELIVERYCHANNEL(0))

    return @SHOULDRUN;

end