UFN_BUSINESSOWNERSHIP_GETOWNERSHIP

Returns all ownership information for a business ownership record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@WPBUSINESSOWNERSHIPID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BUSINESSOWNERSHIP_GETOWNERSHIP(@WPBUSINESSOWNERSHIPID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    ID,
                    NAME,
                    PERCENTOWNERSHIP,
                    VALUE
                from
                    dbo.WPBUSINESSOWNERSHIPOWNERSHIP
                where
                    WPBUSINESSOWNERSHIPID = @WPBUSINESSOWNERSHIPID
            );