USP_STEWARDSHIPPACKAGEREPORT_DISBURSEMENTS

            create proc dbo.USP_STEWARDSHIPPACKAGEREPORT_DISBURSEMENTS(@DESIGNATIONLEVELID uniqueidentifier)
                as
                declare @SQL nvarchar(4000);
                declare @TABLE nvarchar(255);

                begin try
                    select @TABLE = BUSINESSPROCESSOUTPUT.TABLENAME 
                    from dbo.BUSINESSPROCESSOUTPUT inner join dbo.STEWARDSHIPPACKAGEPROCESSHISTORY on BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = STEWARDSHIPPACKAGEPROCESSHISTORY.BUSINESSPROCESSSTATUSGUID
                    where STEWARDSHIPPACKAGEPROCESSHISTORY.ID = @DESIGNATIONLEVELID and BUSINESSPROCESSOUTPUT.TABLEKEY = 'OUTPUT_DISBURSEMENTS';                                    

                    set @SQL = 'select 
                                    dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENTID) as NAME,
                                    DATE, 
                                    AMOUNT                                    
                                from 
                                   dbo.' + @TABLE;                                                     

                    exec sp_executesql @SQL;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch