update menu set menu_status=1 where ModuleMenu_Id=2115
update menu set menu_status=1 where ModuleMenu_Id=2126
Delete menu where  ModuleMenu_Id in (2115,2126)
GO
select * from menu where ModuleMenu_Id in (2115,2126)
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='THLLPANCClosureSummary')
BEGIN
Insert into Sulabels values('THLLPANCClosureSummary',1,'THL','LPA Findings Closure Summary',2,'LPA Findings Closure Summary',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='THLLPAFindingsReportSummary')
BEGIN
Insert into Sulabels values('THLLPAFindingsReportSummary',1,'THL','LPA Findings Report Summary',2,'LPA Findings Report Summary',0,0,0)
END
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='ROLLPAFindingsReportSummary')
BEGIN
Insert into Sulabels values('ROLLPAFindingsReportSummary',1,'THL','LPA Findings Report Summary',9,'LPA Findings Report Summary',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='THLLPANCClosure')
BEGIN
Insert into Sulabels values('THLLPANCClosure',1,'THL','LPA Findings Closure Summary',2,'LPA Findings Closure Summary',0,0,0)
END
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='ROLLPANCClosure')
BEGIN
Insert into Sulabels values('ROLLPANCClosure',1,'THL','LPA Findings Closure Summary',9,'LPA Findings Closure Summary',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='THLLPAFindingsClassificationSummary')
BEGIN
Insert into Sulabels values('THLLPAFindingsClassificationSummary',1,'THL','LPA Findings Classification Summary',2,'LPA Findings Classification Summary',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='ROLLPAFindingsClassificationSummary')
BEGIN
Insert into Sulabels values('ROLLPAFindingsClassificationSummary',1,'THL','LPA Findings Classification Summary',9,'LPA Findings Classification Summary',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='THLLPAExcusePerformanceReport')
BEGIN
Insert into Sulabels values('THLLPAExcusePerformanceReport',1,'THL','LPA Excuse Performance Report',2,'LPA Excuse Performance Report',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='ROLLPAExcusePerformanceReport')
BEGIN
Insert into Sulabels values('ROLLPAExcusePerformanceReport',1,'THL','LPA Excuse Performance Report',9,'LPA Excuse Performance Report',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='ROLLPANCClosureSummary')
BEGIN
Insert into Sulabels values('ROLLPANCClosureSummary',1,'THL','LPA Findings Closure Summary',9,'LPA Findings Closure Summary',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='THLLPAExcuseReport')
BEGIN
Insert into Sulabels values('THLLPAExcuseReport',1,'THL','LPA Excuse Report',2,'LPA Excuse  Report',0,0,0)
END
GO
IF NOT EXISTS (SELECT 1  from sulabels where staticname ='ROLLPAExcuseReport')
BEGIN
Insert into Sulabels values('ROLLPAExcuseReport',1,'THL','LPA Excuse Report',9,'LPA Excuse  Report',0,0,0)
END
GO
delete from menu where ModuleMenu_Id=2133
INSERT into menu Values('THLLPAFindingsReportSummary','THLLPAFindingsReportSummary',2,'?/AuditProReports/LPA_FindingsSummary','AuditPro/nc-report.png',2114,0,'',1,2133,8,1,0,1,'fas fa-border-style')
GO
delete from menu where ModuleMenu_Id=2134
INSERT into menu Values('THLLPANCClosureSummary','THLLPANCClosureSummary',2,'?/AuditProReports/LPA_FindingsClosureSummary','AuditPro/nc-report.png',2114,0,'',1,2134,9,1,0,1,'fas fa-border-style')
GO
delete from menu where ModuleMenu_Id=2135
INSERT into menu Values('THLLPAFindingsClassificationSummary','THLLPAFindingsClassificationSummary',2,'?/AuditProReports/LPA_FindingsClassificationSummary','AuditPro/nc-report.png',2114,0,'',1,2135,10,1,0,1,'fas fa-border-style')
GO
delete from menu where ModuleMenu_Id=2136
INSERT into menu Values('THLLPAExcusePerformanceReport','THLLPAExcusePerformanceReport',2,'?/AuditProReports/LPA_Excuse_Performance','AuditPro/nc-report.png',2114,0,'',1,2136,11,1,0,1,'fas fa-border-style')
GO
delete from menu where ModuleMenu_Id=2137
INSERT into menu Values('THLLPAExcuseReport','THLLPAExcuseReport',2,'?/AuditProReports/LPA_Excuse_Report','AuditPro/nc-report.png',2114,0,'',1,2137,12,1,0,1,'fas fa-border-style')
GO
delete from suModuleRoles where role_id=2913
Insert into suModuleRoles values(2,2913,'Report : LPA Findings Report Summary','Report : LPA Findings Report Summary','ROLLPAFindingsReportSummary','Reports',1)
Go
delete from suModuleRoles where role_id=2914
Insert into suModuleRoles values(2,2914,'Report : LPA Findings Closure Summary','Report : LPA Findings Closure Summary','ROLLPANCClosureSummary','Reports',1)
Go
delete from suModuleRoles where role_id=2915
Insert into suModuleRoles values(2,2915,'Report : LPA Findings Classification Summary','Report : LPA Findings Classification Summary','ROLLPAFindingsClassificationSummary','Reports',1)
Go
delete from suModuleRoles where role_id=2916
Insert into suModuleRoles values(2,2916,'Report : LPA Excuse Performance Report','Report : LPA Excuse Performance Report','ROLLPAExcusePerformanceReport','Reports',1)
Go
delete from suModuleRoles where role_id=2917
Insert into suModuleRoles values(2,2917,'Report : LPA Excuse Report','Report : LPA Excuse Report','ROLLPAExcuseReport','Reports',1)
Go
delete from MenuRoles where menu_id=2133 and role_id=2913
Insert INto MenuRoles values(2133,2913)
GO
delete from MenuRoles where menu_id=2134 and role_id=2914
Insert INto MenuRoles values(2134,2914)
GO
delete from MenuRoles where menu_id=2135 and role_id=2915
Insert INto MenuRoles values(2135,2915)
GO
delete from MenuRoles where menu_id=2136 and role_id=2916
Insert INto MenuRoles values(2136,2916)
GO
delete from MenuRoles where menu_id=2137 and role_id=2917
Insert INto MenuRoles values(2137,2917)
GO
