USP_MKTGIFTRECORDSOURCE_GETMARKETINGINFO

CREATE procedure dbo.[USP_MKTGIFTRECORDSOURCE_GETMARKETINGINFO]
(
  @ID uniqueidentifier,
  @QUERYVIEWCATALOGID uniqueidentifier
)
as
  set nocount on;

  declare @OLDQUERYVIEWCATALOGID uniqueidentifier;
  declare @MARKETINGINFOQUERYVIEWCATALOGID uniqueidentifier;
  declare @REVENUELETTERTABLENAME nvarchar(128);
  declare @REVENUERECEIPTTABLENAME nvarchar(128);

  if exists(select 1 from dbo.[MKTGIFTRECORDSOURCE] where [ID] = @ID)
    select
      @OLDQUERYVIEWCATALOGID = [QUERYVIEWCATALOGID],
      @MARKETINGINFOQUERYVIEWCATALOGID = [MARKETINGINFOQUERYVIEWCATALOGID]
    from dbo.[MKTGIFTRECORDSOURCE]
    where [ID] = @ID;

  set @REVENUELETTERTABLENAME = dbo.[UFN_MKTREVENUELETTER_MAKETABLENAME](@ID);
  set @REVENUERECEIPTTABLENAME = dbo.[UFN_MKTREVENUERECEIPT_MAKETABLENAME](@ID);

  select
    @OLDQUERYVIEWCATALOGID as [OLDQUERYVIEWCATALOGID],
    @MARKETINGINFOQUERYVIEWCATALOGID as [MARKETINGINFOQUERYVIEWCATALOGID],
    dbo.[UFN_REVENUESEGMENT_MAKETABLENAME](@ID) as [REVENUESEGMENTTABLENAME],
    [DISPLAYNAME] as [SOURCEVIEWDISPLAYNAME],
    [OBJECTNAME] as [PARENTVIEW],
    [PRIMARYKEYFIELD] as [PARENTVIEWRELATEDFIELD],
    @REVENUELETTERTABLENAME as [REVENUELETTERTABLENAME],
    @REVENUERECEIPTTABLENAME as [REVENUERECEIPTTABLENAME],
    (select [ID] from dbo.[TABLECATALOG] where [TABLENAME] = @REVENUELETTERTABLENAME) as [REVENUELETTERTABLECATALOGID],
    (select [ID] from dbo.[TABLECATALOG] where [TABLENAME] = @REVENUERECEIPTTABLENAME) as [REVENUERECEIPTTABLECATALOGID],
    dbo.[UFN_MKTRECORDSOURCE_MAKEMATCHBACKTABLENAME](@ID) as [MATCHBACKTABLENAME]
  from dbo.[QUERYVIEWCATALOG]
  where [ID] = @QUERYVIEWCATALOGID;

  return 0;