UFN_BUSINESSPROCESS_GETIDFROMSTATUSID

            create function dbo.UFN_BUSINESSPROCESS_GETIDFROMSTATUSID
            (
                @BUSINESSPROCESSSTATUSID uniqueidentifier
            )
            returns uniqueidentifier
            with execute as caller
            as
            begin
                declare @ID uniqueidentifier;

                select 
                    @ID = BUSINESSPROCESSSTATUS.BUSINESSPROCESSCATALOGID
                from 
                    dbo.BUSINESSPROCESSOUTPUT
                inner join
                    dbo.BUSINESSPROCESSSTATUS on BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = BUSINESSPROCESSSTATUS.ID
                where
                    BUSINESSPROCESSSTATUS.ID = @BUSINESSPROCESSSTATUSID;

                return @ID;
            end