USP_DATAFORMTEMPLATE_VIEW_MATCHINGGIFTCLAIMOPPORTUNITYDEFAULTSOLICITORS

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MATCHINGGIFTCLAIMOPPORTUNITYDEFAULTSOLICITORS
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @CANDEFAULTSOLICITORS bit = null output
)
as
  set nocount on;

  set @DATALOADED = 1;
  set @CANDEFAULTSOLICITORS = 0;

  declare @CREDITRULES bit = 0;
  declare @OPPORTUNITYSOLICITORS bit = 0;

  select @CREDITRULES = 1 from dbo.SOLICITORCREDITRULES where APPLYTOMATCHINGGIFTCLAIMS = 1;

  select @OPPORTUNITYSOLICITORS = 1
  from dbo.OPPORTUNITY
    inner join dbo.PROSPECTPLAN on OPPORTUNITY.PROSPECTPLANID = PROSPECTPLAN.ID
    left join dbo.SECONDARYFUNDRAISER on PROSPECTPLAN.ID = SECONDARYFUNDRAISER.PROSPECTPLANID
  where OPPORTUNITY.ID = @ID
    and (PROSPECTPLAN.PRIMARYMANAGERFUNDRAISERID is not null
          or PROSPECTPLAN.SECONDARYMANAGERFUNDRAISERID is not null
          or SECONDARYFUNDRAISER.ID is not null);

  if @CREDITRULES = 1 and @OPPORTUNITYSOLICITORS = 1
      set @CANDEFAULTSOLICITORS = 1;

  return 0;