USP_SIMPLEDATALIST_BATCHWORKFLOW

                CREATE procedure dbo.USP_SIMPLEDATALIST_BATCHWORKFLOW(@BATCHTYPECATALOGID uniqueidentifier)
                as
                    set nocount on;
                    select 
                        BATCHWORKFLOW.ID value, 
                        BATCHWORKFLOW.NAME label 
                    from 
                        dbo.BATCHWORKFLOW
                        inner join dbo.BATCHWORKFLOWSTATE on BATCHWORKFLOW.ID = BATCHWORKFLOWSTATE.BATCHWORKFLOWID
            --adding or BATCHWORKFLOW.BATCHTYPECATALOGID is null since batch type has been moved from the work flow onto the batch template

                    where (BATCHWORKFLOW.BATCHTYPECATALOGID = @BATCHTYPECATALOGID or BATCHWORKFLOW.BATCHTYPECATALOGID is null) and BATCHWORKFLOWSTATE.ISINITIALSTATE = 1
                    order by label;