USP_BUSINESSPROCESS_GETPARAMETERSETINFO

CREATE procedure [dbo].[USP_BUSINESSPROCESS_GETPARAMETERSETINFO] (
    @PARAMETERSETID as uniqueidentifier, 
    @NAME as nvarchar(100) output, 
    @RECORDTYPEID as uniqueidentifier output,
    @BUSINESSPROCESSCATALOGID as uniqueidentifier output,
    @PARAMETERTABLENAME as nvarchar(100) output
)
as
begin
    set nocount on;

    select 
        @NAME = V.NAME,
        @RECORDTYPEID = BP.RECORDTYPEID,
        @BUSINESSPROCESSCATALOGID = BP.ID,
        @PARAMETERTABLENAME = BP.PARAMETERTABLENAME
    from 
        dbo.V_BUSINESSPROCESSPARAMETERSETS as V inner join dbo.BUSINESSPROCESSCATALOG as BP on V.BUSINESSPROCESSID = BP.ID
    where 
        V.PARAMETERSETID = @PARAMETERSETID

    return 0;
end