USP_OTHERPAYMENTMETHODCODE_GETLIST

Returns the set of table entries for the "Other Payment Method Type" code table.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Input parameter indicating whether or not to include inactive code table entries in the list.
@APPUSERID	uniqueidentifier	IN

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  9/30/2015 1:00:48 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_OTHERPAYMENTMETHODCODE_GETLIST(@INCLUDEINACTIVE bit, @APPUSERID uniqueidentifier = null)
AS
    declare @ISSYSADMIN bit;
select @ISSYSADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@APPUSERID);

    if dbo.UFN_GETLISTSORTMETHOD('OTHERPAYMENTMETHODCODE') = 0
        begin
            if @INCLUDEINACTIVE = 0
                select ID, DESCRIPTION, [SEQUENCE], ACTIVE from dbo.OTHERPAYMENTMETHODCODE where ACTIVE = 1 and (@APPUSERID is null or @ISSYSADMIN = 1 or (dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRY(@APPUSERID, OTHERPAYMENTMETHODCODE.ID) = 1)) order by DESCRIPTION
            else
                select ID, DESCRIPTION, [SEQUENCE], ACTIVE from dbo.OTHERPAYMENTMETHODCODE where @APPUSERID is null or @ISSYSADMIN = 1 or (dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRY(@APPUSERID, OTHERPAYMENTMETHODCODE.ID) = 1) order by DESCRIPTION    
            end
    else
        begin
            if @INCLUDEINACTIVE = 0
                select ID, DESCRIPTION, [SEQUENCE], ACTIVE from dbo.OTHERPAYMENTMETHODCODE where ACTIVE = 1 and (@APPUSERID is null or @ISSYSADMIN = 1 or (dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRY(@APPUSERID, OTHERPAYMENTMETHODCODE.ID) = 1)) order by SEQUENCE
            else
                select ID, DESCRIPTION, [SEQUENCE], ACTIVE from dbo.OTHERPAYMENTMETHODCODE where @APPUSERID is null or @ISSYSADMIN = 1 or (dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRY(@APPUSERID, OTHERPAYMENTMETHODCODE.ID) = 1) order by SEQUENCE
            end