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
(734, '734', 'Jeevan Tarun', 'M', 1, 1, 0,
0, 13, 25, 0, 1, 0, 1,
0, 'Nov 18, 2024', 0, '934', 'ENP', 
1, null, '1', 0, 
0, 1, 0, null, 1,
1, 1, 200000, null, 0, 0, 7340, 
5000, 0, 'M', 0, 0, 0, 'LIC')

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7341, 734, 'Y')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7342, 734, 'H')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7343, 734, 'Q')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7344, 734, 'E')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7345, 734, 'S')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73401, 1, 9, 1, 1,  'Y', 8, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73402, 1, 9, 2, 5,  'Y', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73403, 8, 8, 6, 7, 'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73475, 8, 8, 8, 8, 'Y', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73476, 9, 9, 6, 8, 'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73477, 9, 9, 9, 9, 'Y', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73404, 10, 14, 1, 1,  'Y', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73405, 10, 14, 2, 5,  'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73406, 10, 14, 6, 99, 'Y', 5, 0.00)

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

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

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73410, 1, 9, 1, 1,  'H', 8, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73411, 1, 9, 2, 5,  'H', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73412, 8, 8, 6, 7, 'H', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73478, 8, 8, 8, 8, 'H', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73479, 9, 9, 6, 8, 'H', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73480, 9, 9, 9, 9, 'H', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73413, 10, 14, 1, 1,  'H', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73414, 10, 14, 2, 5,  'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73415, 10, 14, 6, 99, 'H', 5, 0.00)

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

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

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73419, 1, 9, 1, 1,  'Q', 8, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73420, 1, 9, 2, 5,  'Q', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73421, 8, 8, 6, 7, 'Q', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73481, 8, 8, 8, 8, 'Q', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73482, 9, 9, 6, 8, 'Q', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73483, 9, 9, 9, 9, 'Q', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73422, 10, 14, 1, 1,  'Q', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73423, 10, 14, 2, 5,  'Q', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73424, 10, 14, 6, 99, 'Q', 5, 0.00)

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

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

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73428, 1, 9, 1, 1,  'E', 8, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73429, 1, 9, 2, 5,  'E', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73430, 8, 8, 6, 7, 'E', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73484, 8, 8, 8, 8, 'E', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73485, 9, 9, 6, 8, 'E', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73486, 9, 9, 9, 9, 'E', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73431, 10, 14, 1, 1,  'E', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73432, 10, 14, 2, 5,  'E', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73433, 10, 14, 6, 99, 'E', 5, 0.00)

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

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

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73437, 1, 9, 1, 1,  'S', 8, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73438, 1, 9, 2, 5,  'S', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73439, 8, 8, 6, 7, 'S', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73487, 8, 8, 8, 8, 'S', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73488, 9, 9, 6, 8, 'S', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73489, 9, 9, 9, 9, 'S', 5.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73440, 10, 14, 1, 1,  'S', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73441, 10, 14, 2, 5,  'S', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (734, 73442, 10, 14, 6, 99, 'S', 5, 0.00)

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

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

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

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

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

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (734, 'Jeevan Tarun', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (734, 'thou r#.k', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (734, 'thou r#.k', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (734, 'Y´É{É lÉ¯iÉ', 'GUJ')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo)
Values (734, 73401, 2)

Update InsurancePlan Set HighlightColor = '$00B1FCF8' where PlanInternalno in (734)

insert into SurvivalBenefit(PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment, PremiumPayingTerm)
select 734, SurvivalBenefitInternalNo - 200000, Term, Month, Installment, PremiumPayingTerm
  From SurvivalBenefit
Where PlanInternalno = 934
order by SurvivalBenefitInternalno
