USP_SIMPLEDATALIST_GENERATEBACSFILEBATCHTEMPLATEBYUSER

                CREATE procedure dbo.USP_SIMPLEDATALIST_GENERATEBACSFILEBATCHTEMPLATEBYUSER
                (
                    @CURRENTAPPUSERID uniqueidentifier
                ) 
                as
                    select distinct 
                        BATCHTEMPLATE.ID as VALUE, 
                        BATCHTEMPLATE.NAME as LABEL 
                    from 
                        dbo.BATCHTEMPLATE
                        left join dbo.BATCHTYPECATALOG
                            on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
                    where 
                        dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHPROCESSOR(@CURRENTAPPUSERID, BATCHTEMPLATE.ID) = 1 
                        and BATCHTEMPLATE.CUSTOM = 0 
                        and ACTIVE = 1
                        and BATCHTYPECATALOG.CATEGORY = 'REVENUE'
                    order by LABEL;