USP_RECORDOPERATION_GETMETADATA_FOREXECUTION

CREATE procedure [dbo].[USP_RECORDOPERATION_GETMETADATA_FOREXECUTION](@ID uniqueidentifier)
as begin
    set nocount on
    select 
        R.IMPLEMENTATIONTYPE as RECORDOPERATIONTYPE,
        R.PROCEDURENAME,
        R.ASSEMBLYNAME,
        R.CLASSNAME,
        R.STATICPARAMETERDEFINITION,
        cast(case when P.SPECIFIC_SCHEMA is null then 0 else 1 end as bit) as HASAPPUSER,
        R.RECORDOPERATIONSPECXML
    from
        dbo.RECORDOPERATIONCATALOG R
        left outer join INFORMATION_SCHEMA.PARAMETERS P on P.SPECIFIC_SCHEMA='dbo' and P.SPECIFIC_NAME = PROCEDURENAME and P.PARAMETER_NAME = '@CURRENTAPPUSERID'
    where
        R.ID = @ID

    return 0
end