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
(908, 908, 'New Cancer Cover', 'H', 0, 1, 1,
0, 10, 15, 0, 0, 0, 0,
0, 'Oct 19, 2026', 0, NULL, NULL, 
0, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 1500000, 5000000, 0, 0, 9080,
100000, 0, 'H', 0, 0, 0, 'LIC')

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (908, 'New Cancer Cover', 'ENG')

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (908, 'U;w dWUlj dOgj', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (908, 'U;w dWUlj dOgj', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (908, '{ H{ H', 'GUJ')

Insert Into Mode values (9081, 908, 'Y')
Insert Into Mode values (9082, 908, 'H')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (908, 90801, 10, 14, 1, 1,  'Y', 15, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (908, 90802, 15, 15, 1, 1,  'Y', 20, 0.4)


insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (908, 90803, 0, 99, 2, 6,  'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (908, 90804, 0, 99, 7, 99,  'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (908, 90805, 10, 14, 1, 1,  'H', 15, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (908, 90806, 15, 15, 1, 1,  'H', 20, 0.4)


insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (908, 90807, 0, 99, 2, 6,  'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (908, 90808, 0, 99, 7, 99,  'H', 5, 0.00)

Update InsurancePlan Set HighlightColor = '$00FFFFE7' where PlanInternalno = 908

Insert into Underwritting values (433, 'Invaid SA', 'SA must be >= 35,00,000 (Age 18-34), 30,00,000(Age 35-40), 20,00,000(Age 41-50), 15,00,000(Age 51 & above)')