Delete after a join condition

DeleteRowsAfterJoinCondition.sql

DROP TABLE IF EXISTS #toDelete
SELECT bmi.* INTO #toDelete
FROM [dbo].[BCS_Main_Input_With_absence_Holiday_And_Wage_Elements] bmi
INNER JOIN @fiscalWeeksForRelease fw 
on
	fw.FISCAL_YEAR = bmi.Fiscal_Year
	AND fw.FISCAL_WEEK = bmi.Fiscal_Week
INNER JOIN @StoresInRelease s
on
	s.Store_Id = bmi.Store_ID
WHERE Release_Id <> @par_Release_Id

DELETE FROM [dbo].[BCS_Main_Input_With_absence_Holiday_And_Wage_Elements]
WHERE EXISTS (
	SELECT * FROM #toDelete tdl
	WHERE tdl.Release_Id = [dbo].[BCS_Main_Input_With_absence_Holiday_And_Wage_Elements].Release_Id
	AND tdl.Store_ID = [dbo].[BCS_Main_Input_With_absence_Holiday_And_Wage_Elements].Store_ID
	AND tdl.Fiscal_Year = [dbo].[BCS_Main_Input_With_absence_Holiday_And_Wage_Elements].Fiscal_Year
	AND tdl.Fiscal_Period = [dbo].[BCS_Main_Input_With_absence_Holiday_And_Wage_Elements].Fiscal_Period
	AND tdl.Fiscal_Week = [dbo].[BCS_Main_Input_With_absence_Holiday_And_Wage_Elements].Fiscal_Week
	AND tdl.BCS_Code = [dbo].[BCS_Main_Input_With_absence_Holiday_And_Wage_Elements].BCS_Code)