USP_DATAFORMTEMPLATE_ADD_BATCHREVENUESEPAMANDATE_PRELOAD

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHREVENUESEPAMANDATE_PRELOAD
(
    @CONSTITUENTACCOUNTID uniqueidentifier,
    @CONSTITUENTACCOUNTDESCRIPTION nvarchar(255) = null output
)
as
    set nocount on;

    exec dbo.USP_GET_KEY_ACCESS;

    select @CONSTITUENTACCOUNTDESCRIPTION = dbo.UFN_BATCHREVENUECONSTITUENTACCOUNT_GETDESCRIPTION(@CONSTITUENTACCOUNTID);

    if @CONSTITUENTACCOUNTDESCRIPTION = ''
        select @CONSTITUENTACCOUNTDESCRIPTION = dbo.UFN_BATCHSPONSORSHIPCONSTITUENTACCOUNT_GETDESCRIPTION(@CONSTITUENTACCOUNTID);

    exec dbo.USP_CLOSE_KEY_ACCESS;

    return 0;