USP_SIMPLEDATALIST_TRIBUTELETTERCODE

Returns a list of tribute letters.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_TRIBUTELETTERCODE
                (
                  @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        ID as VALUE,
                        NAME as LABEL
                    from
                        dbo.TRIBUTELETTERCODE
                    where
                        ISACTIVE = 1 and
                        dbo.UFN_TRIBUTELETTERCODE_USERHASSITEACCESS(@CURRENTAPPUSERID, TRIBUTELETTERCODE.ID) = 1
                    order by
                        NAME;