USP_GET_SITEPAGE_BBPAYTEMPLATEVERSION_PRODUCTION

create procedure dbo.USP_GET_SITEPAGE_BBPAYTEMPLATEVERSION_PRODUCTION
(
  @SITEPAGEID integer
)
as
begin
        -- Get the production environment ID

      declare @PRODUCTIONENVIRONMENTID uniqueidentifier;
      select @PRODUCTIONENVIRONMENTID = ID from dbo.CRMBBEnvironment where DESCRIPTIONTEXT = 'Production';
      -- Get the template settings for the production environment

      exec USP_GET_SITEPAGE_BBPAYTEMPLATEVERSION @SITEPAGEID, @PRODUCTIONENVIRONMENTID;
end