USP_DATAFORMTEMPLATE_VIEW_EVENTTEAMFUNDRAISINGHIERARCHY

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTTEAMFUNDRAISINGHIERARCHY
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @EVENTID uniqueidentifier= null output,
    @APPEALID uniqueidentifier = null output,
    @APPEALNAME nvarchar(100) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @EVENTID = EVENT.ID,
        @APPEALID = EVENT.APPEALID,
        @APPEALNAME = dbo.UFN_APPEAL_GETNAME(EVENT.APPEALID)
    from
        dbo.EVENT
    where
        EVENT.ID = @ID
        and EVENT.APPEALID is not null;

    return 0;