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
(745, 745, 'Jeevan Umang', 'W', 1, 1, 1,
1, 45, 100, 1, 1, 0, 1,
0, 'Oct 1, 2024', 0, '945', 'ENP', 
1, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 200000, null, 0, 0, 7450,
25000, 0, 'W', 0, 0, 0, 'LIC')

Insert Into Mode values (74501, 745, 'Y')
Insert Into Mode values (74502, 745, 'H')
Insert Into Mode values (74503, 745, 'Q')
Insert Into Mode values (74504, 745, 'E')
Insert Into Mode values (74505, 745, 'S')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (745, 74501, 6)
Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (745, 74502, 11)
Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (745, 74504, 2)

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

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

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

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

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

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

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

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

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

Insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (745, 74508, 15, 99, 2, 5,  'Q', 7.5, 0.00)

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

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

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

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

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

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

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

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (745, 'ENG', 'Jeevan Umang')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (745, 'MAR', 'thou meax')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (745, 'HIN', 'thou meax')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (745, 'GUJ', 'Y´É{É A©ÉÅNÉ')

insert into SurvivalBenefit (PlanInternalNo, SurvivalBenefitInternalNo, Term, Month,Installment, PremiumPayingTerm)
select 745, SurvivalBenefitInternalNo - 2000000, Term, Month, Installment, PremiumPayingTerm 
from SurvivalBenefit where PlanInternalno = 945
