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
(715, 715, 'New Jeevan Anand', 'E', 1, 0, 0,
1, 15, 35, 1, 0, 0, 1,
0, 'Oct 1, 2024', 0, '915', 'ENP', 
1, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 200000, null, 0, 0, 7150,
5000, 0, 'E', 0, 0, 0, 'LIC')

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7151, 715, 'Y')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7152, 715, 'H')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7153, 715, 'Q')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7154, 715, 'E')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7155, 715, 'S')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71501, 15, 99, 1, 1,  'Y', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71502, 15, 99, 2, 5,  'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71503, 15, 99, 6, 99, 'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71504, 15, 99, 1, 1,  'H', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71505, 15, 99, 2, 5,  'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71506, 15, 99, 6, 99, 'H', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71507, 15, 99, 1, 1,  'Q', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71508, 15, 99, 2, 5,  'Q', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71509, 15, 99, 6, 99, 'Q', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71510, 15, 99, 1, 1,  'E', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71511, 15, 99, 2, 5,  'E', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71512, 15, 99, 6, 99, 'E', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71513, 15, 99, 1, 1,  'S', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71514, 15, 99, 2, 5,  'S', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (715, 71515, 15, 99, 6, 99, 'S', 5, 0.00)

Insert Into PlanServiceTax (PlanInternalNo, PlanServiceTaxInternalNo, StartDate, EndDate, FromDuration, ToDuration, Tax, FromPremiumPayingTerm, ToPremiumPayingTerm)
Values (715, 7151, 'April 1, 2024', null, 1, 1, 4.5, 1, 100)

Insert Into PlanServiceTax (PlanInternalNo, PlanServiceTaxInternalNo, StartDate, EndDate, FromDuration, ToDuration, Tax, FromPremiumPayingTerm, ToPremiumPayingTerm)
Values (715, 7152, 'April 1, 2024', null, 2, 99, 2.25, 1, 100)

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (715, 'New Jeevan Anand', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (715, 'U;w thou vkuan', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (715, 'U;w thou vkuan', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (715, '{«ÉÖ Y´É{É +É{ÉÅq', 'GUJ')

insert into SurvivalBenefit (PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment, PremiumPayingTerm)
select 715, SurvivalBenefitInternalNo - 1130000,  Term, Month, Installment, PremiumPayingTerm from survivalBenefit where PlanInternalno = 815

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (715, 7151, 11)
Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (715, 7154, 6)