UFN_BUSINESSPROCESS_GETBUSINESSPROCESSOUTPUTVIEWS

create function dbo.UFN_BUSINESSPROCESS_GETBUSINESSPROCESSOUTPUTVIEWS
(
    @BUSINESSPROCESSCATALOGID uniqueidentifier
)
returns table
as 
return
    select
        BUSINESSPROCESSVIEW.ID as BUSINESSPROCESSVIEWID,
        case when QUERYVIEWSPEC.value
        (
            'declare namespace bbafx="bb_appfx_queryview";
            declare namespace c="bb_appfx_commontypes";
            (bbafx:QueryViewSpec/bbafx:TVFImplementation/@FunctionName)[1]','char(100)'
        ) is null then 0 else 1 end as HASPARAMETERS,
        BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID as QUERYID
    from
        dbo.QUERYVIEWCATALOG
    inner join
        dbo.BUSINESSPROCESSVIEW on QUERYVIEWCATALOG.ID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID
    where
        BUSINESSPROCESSVIEW.BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID;