USP_SIMPLEDATALIST_BUSINESSPROCESSWITHPARAMETERSET

                create procedure dbo.USP_SIMPLEDATALIST_BUSINESSPROCESSWITHPARAMETERSET
                as
                    set nocount on;

                    select ID as VALUE,
                        NAME as LABEL                        
                    from dbo.BUSINESSPROCESSCATALOG 
                    where
                        1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
                        (
                            BUSINESSPROCESSCATALOG.BUSINESSPROCESSSPECXML.query
                                (
                                    'declare namespace common="bb_appfx_commontypes";
                                    /*/common:InstalledProductList'
                                )
                        ) and
                        PARAMETERTABLENAME is not null
                    order by NAME
                    ;