Invalid Object Name #TargetDateTblx

CREATE PROCEDURE [dbo].[CZ_SummaryCustomerNameDeliveryStatus] 

AS
BEGIN
	SET NOCOUNT ON;
DECLARE @SQL NVARCHAR(MAX)

SET @SQL = 
'	
	CREATE TABLE #TargetDateTblx(IssueID VARCHAR(100), TargetDate VARCHAR(100))
	INSERT [#TargetDateTblx]
	SELECT issueid, [fielddata] AS TargetDate
	FROM rndbug.dbo.gemini_customfielddata
	WHERE customfieldid = 215 AND LEN(fielddata) > 0			


	CREATE TABLE #ActualDateTblx(IssueID VARCHAR(100), ActualDate VARCHAR(100))
	INSERT [#ActualDateTblx]
	SELECT issueid, [fielddata] AS ActualDate
	FROM rndbug.dbo.gemini_customfielddata
	WHERE customfieldid = 217				


	CREATE TABLE #CompleteRateTblx(IssueID VARCHAR(100), CompleteRate VARCHAR(100))
	INSERT [#CompleteRateTblx]
	SELECT issueid, [fielddata] AS CompleteRate
	FROM rndbug.dbo.gemini_customfielddata
	WHERE customfieldid = 234  AND fielddata = 100


	CREATE TABLE #CustomerNamess(IssueID VARCHAR(100), CustName VARCHAR(50))
	INSERT [#CustomerNamess]
	SELECT issueid, [fielddata] AS CustName
	FROM rndbug.dbo.gemini_customfielddata
	WHERE customfieldid = 200


	CREATE TABLE #SummaryTbl(YEARS VARCHAR(100), January VARCHAR(100), February VARCHAR(100),March VARCHAR(100), April VARCHAR(100), May VARCHAR(100),June VARCHAR(100), July VARCHAR(100), August VARCHAR(100),September VARCHAR(100),October VARCHAR(100), November VARCHAR(100),December VARCHAR(100), Total VARCHAR(100))
	INSERT [#SummaryTbl] 
	SELECT
	YEARS,
	[1] AS January,
	[2] AS February,
	[3] AS March, 
	[4] AS April,
	[5] AS May,
	[6] AS June,
	[7] AS July, 
	[8] AS August,
	[9] AS September,
	[10] AS October,
	[11] AS November,
	[12] AS December, 
	[1]+[2]+[3]+[4]+[5]+[6]+[7]+[8]+[9]+[10]+[11]+[12] [Total]
	FROM(
	SELECT CustName, SUBSTRING(ActualDate, 5, 1) AS Months, SUBSTRING(ActualDate, 7, 4) AS YEARS 
	FROM #CustomerNamess C
	LEFT JOIN #ActualDateTblx A
	ON C.IssueID = A.IssueID
	LEFT JOIN #CompleteRateTblx O
	ON C.IssueID = O.IssueID
	WHERE CompleteRate = 100 AND LEN(SUBSTRING(ActualDate, 7, 4))=4 
	)TableDate
	
	PIVOT
	(
		COUNT (CustName) FOR Months IN ([1], [2], [3], [4], [5], [6], [7],[8],[9],[10],[11],[12])
	) PIVOTCOUNT  
	
	SELECT * FROM #SummaryTbl
	'
	
	
SELECT @SQL = @SQL
EXEC sp_executesql @SQL

END