USP_DATAFORMTEMPLATE_ADD_SEPAMANDATE_PRELOAD

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

    exec dbo.USP_GET_KEY_ACCESS;

    select
        @CONSTITUENTACCOUNTDESCRIPTION = dbo.UFN_CONSTITUENTACCOUNT_GETDESCRIPTION(CONSTITUENTACCOUNT.ID)
    from
        dbo.CONSTITUENTACCOUNT
    where
        CONSTITUENTACCOUNT.ID = @CONSTITUENTACCOUNTID;

    exec dbo.USP_CLOSE_KEY_ACCESS;

    return 0;