UFN_SPONSORSHIPPROGRAM_GROUPANDGREATESTNEEDCONSISTENT
Checks that the opportunity group and greatest need rule set on the specified program apply to the same opportunity type.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPONSORSHIPOPPORTUNITYGROUPID | uniqueidentifier | IN | |
| @SPONSORSHIPGREATESTNEEDRULESETID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SPONSORSHIPPROGRAM_GROUPANDGREATESTNEEDCONSISTENT(
@SPONSORSHIPOPPORTUNITYGROUPID uniqueidentifier,
@SPONSORSHIPGREATESTNEEDRULESETID uniqueidentifier
)
returns bit
with execute as caller
as begin
declare @VALID bit
select @VALID = case when SPONSORSHIPOPPORTUNITYGROUP.SPONSORSHIPOPPORTUNITYTYPECODE = SPONSORSHIPGREATESTNEEDRULESET.SPONSORSHIPOPPORTUNITYTYPECODE then 1 else 0 end
from dbo.SPONSORSHIPOPPORTUNITYGROUP
inner join dbo.SPONSORSHIPGREATESTNEEDRULESET on SPONSORSHIPGREATESTNEEDRULESET.ID = @SPONSORSHIPGREATESTNEEDRULESETID
where SPONSORSHIPOPPORTUNITYGROUP.ID = @SPONSORSHIPOPPORTUNITYGROUPID;
return @VALID
end