insert into InsurancePlan (
PlanInternalNo, PlanNo, PlanName, PlanType, WithProfit, NonMedicalGeneral, NonMedicalSpecial, 
NearBirthday, MinimumTerm, MaximumTerm, TermRider, PremiumWaiver, CashOption, LoanGeneral, 
LoanHousing, StartDate, GuranteedAddition, BonusType, FinalAdditionalBonusType,
DeductLoanFromReturn, LoyaltyAdditionType, SurrenderTable, InBuiltAccident, 
AccidentDeathBenefit, NormalDeathBenefit, JointLife, ExpiryDate, UseInPresentation, 
ApplicableMale, ApplicableFemale, MinSA,  MaxSa, MinVestingAge, MaxVestingAge, OrderNo, 
MultipleOf, ChildTermRider, Category, IncomeBenefit, FemaleIllness, CongenitalDisability,
CompanyShortName)
Values
(886, 886, 'Protection Plus', 'E', 0, 1, 1,
1, 10, 25, 0, 0, 0, 0,
0, 'Dec 3, 2025', 0, NULL, NULL, 
1, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 0, null, 0, 0, 8860,
1000, 0, 'E', 0, 0, 0, 'LIC')


Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (8861, 886, 4, 10, 4, 0)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (8862, 886, 1, 10, 6, 1)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (8863, 886, 2, 10, 8, 0)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (8864, 886, 6, 10, 10, 0)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (8865, 886, 14, 10, 10, 0)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (8866, 886, 15, 10, 10, 0)

insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (886, 4, 'Dec 3, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (886, 1, 'Dec 3, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (886, 2, 'Dec 3, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (886, 6, 'Dec 3, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (886, 14, 'Dec 3, 2024', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (886, 15, 'Dec 3, 2024', 10)

Insert Into Mode values (8861, 886, 'Y')
Insert Into Mode values (8862, 886, 'H')
Insert Into Mode values (8863, 886, 'Q')
Insert Into Mode values (8864, 886, 'E')

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (886, 'ENG', 'Protection Plus')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (886, 'MAR', 'VD''ku Iyl')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (886, 'HIN', 'VD''ku Iyl')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (886, 'GUJ', 'G{ ~ɻ')

Insert into Underwritting values (425, 'Invaid Age', 'Max Allowed Age is 50 Years (Near Birthday)')

Update InsurancePlan Set HighlightColor = '$00FCFBE0' where PlanInternalno in (886) 

