UFN_WPBUSINESSOWNERSHIP_OWNERSHIP

Gets a table of ownership details for a given WPBUSINESSOWNERSHIP ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@WPBUSINESSOWNERSHIPID	uniqueidentifier	IN

Definition

Copy



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