USP_STEWARDSHIPPACKAGEREPORT_DECAPITALIZATIONS

              create proc dbo.USP_STEWARDSHIPPACKAGEREPORT_DECAPITALIZATIONS(@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_DECAPITALIZATIONS';                                    

                  set @SQL = 'select 
                                  APPROVALDATE, 
                                  dbo.UFN_CONSTITUENT_BUILDNAME(APPROVEDBYID) as APPROVEDBY,
                                  AMOUNT                                    
                              from 
                                  dbo.' + @TABLE;                                                     

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