UFN_WEALTHCAPACITYFORMULA_INCOMECOMPENSATION_GETSOURCES

Returns income/compensation sources associated with a wealth formula.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@WEALTHCAPACITYFORMULAID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_WEALTHCAPACITYFORMULA_INCOMECOMPENSATION_GETSOURCES(
            @WEALTHCAPACITYFORMULAID uniqueidentifier
            ) 
            returns table
            as return
                select
                    ID,
                    SOURCE    
                from
                    dbo.WEALTHCAPACITYFORMULAINCOMECOMPENSATIONSOURCE
                where
                    WEALTHCAPACITYFORMULAID=@WEALTHCAPACITYFORMULAID