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
(883, 883, 'Jeevan Utsav Single Premium', 'W', 1, 0, 0,
1, 35, 100, 1, 0, 0, 1,
0, 'Jan 12, 2026', 40, null, null, 
1, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 500000, null, 0, 0, 8830,
25000, 0, 'W', 0, 0, 0, 'LIC')

Insert Into Mode values (88301, 883, 'P')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (883, 88301, 11)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (883, 88301, 1, 100, 1, 1,  'P', 2, 0.00)

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (883, 'ENG', 'Jeevan Utsav Single Premium')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (883, 'MAR', 'thou mRlo & ,djdeh')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (883, 'HIN', 'thou mRlo ,dy hfe;e')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (883, 'GUJ', 'Y{ Alɴ +H W  ҩҫɩ')
Insert into Underwritting values (426, 'Invalid Age', 'Min Age at the end of Accumulation Term must be 17 years completed')

Delete From SSVNew Where PlanInternalNo = 758
