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
(764, 764, 'Bima Ratna', 'M', 1, 0, 0,
1, 15, 25, 1, 1, 0, 1,
0, 'Jan 1, 2025', 50, Null, Null, 
1, null, 'N', 0, 
1, 1.25, 0, null, 1,
1, 1, 500000, null, 0, 0, 7640,
25000, 0, 'M', 0, 0, 0, 'LIC')

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7641, 764, 'Y')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7642, 764, 'H')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7643, 764, 'Q')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7644, 764, 'E')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7645, 764, 'S')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76401, 11, 11, 1, 1,  'Y', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76402, 11, 11, 2, 6,  'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76403, 11, 11, 7, 11, 'Y', 5, 0.00)

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76405, 15, 99, 2, 6,  'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76406, 15, 99, 7, 21, 'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76407, 11, 11, 1, 1,  'H', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76408, 11, 11, 2, 6,  'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76409, 11, 11, 7, 11, 'H', 5, 0.00)

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76416, 15, 99, 2, 6,  'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76417, 15, 99, 7, 21, 'H', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76419, 11, 11, 1, 1,  'Q', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76420, 11, 11, 2, 6,  'Q', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76421, 11, 11, 7, 11, 'Q', 5, 0.00)

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76428, 15, 99, 2, 6,  'Q', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76429, 15, 99, 7, 21, 'Q', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76441, 11, 11, 1, 1,  'E', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76442, 11, 11, 2, 6,  'E', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76443, 11, 11, 7, 11, 'E', 5, 0.00)

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76450, 15, 99, 2, 6,  'E', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76451, 15, 99, 7, 21, 'E', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76453, 11, 11, 1, 1,  'S', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76454, 11, 11, 2, 6,  'S', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76455, 11, 11, 7, 11, 'S', 5, 0.00)

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76462, 15, 99, 2, 6,  'S', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (764, 76463, 15, 99, 7, 21, 'S', 5, 0.00)

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

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

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (764, 'Bima Ratna', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (764, 'fcek jRu', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (764, 'fcek jRu', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (764, '¥ÉÒ©ÉÉ ùl{É', 'GUJ')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (764, 76401, 6)
Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (764, 76402, 11)
Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (764, 76403, 2)

insert into survivalBenefit (PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (764, 7640001, 15, 156, 1)

insert into survivalBenefit (PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (764, 7640002, 15, 168, 2)

insert into survivalBenefit (PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (764, 7640003, 20, 216, 1)

insert into survivalBenefit (PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (764, 7640004, 20, 228, 2)

insert into survivalBenefit (PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (764, 7640005, 25, 276, 1)

insert into survivalBenefit (PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (764, 7640006, 25, 288, 2)

Insert into Underwritting values (416, 'Invalid Age', 'Max Allowed Age is 55 Years (Near Birthday)')