UFN_SPONOSRSHIPOPPORTUNITY_REASONS

Returns the sponsorship reasons associated with an ineligible opportunity

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SPONSORSHIPOPPORTUNITYID	uniqueidentifier	IN

Definition

Copy



            CREATE function [dbo].[UFN_SPONOSRSHIPOPPORTUNITY_REASONS]
            (
                @SPONSORSHIPOPPORTUNITYID uniqueidentifier
            )
            returns table
            as
                return(
                    select
                        SPONSORSHIPOPPORTUNITYREASON.ID,
                        SPONSORSHIPOPPORTUNITYREASON.SPONSORSHIPREASONID
            from SPONSORSHIPOPPORTUNITYREASON
            where SPONSORSHIPOPPORTUNITYREASON.SPONSORSHIPOPPORTUNITYID = @SPONSORSHIPOPPORTUNITYID   )