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
(752, 752, 'LIC SIIP', 'E', 0, 1, 1,
1, 10, 25, 0, 0, 0, 0,
0, 'Jan 1, 2025', 0, NULL, NULL, 
1, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 0, null, 0, 0, 7520,
10000, 0, 'E', 0, 0, 0, 'LIC')

Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (7521, 752, 4, 10, 4, 0)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (7522, 752, 1, 10, 6, 1)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (7523, 752, 2, 10, 8, 0)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (7524, 752, 6, 10, 10, 0)

insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (752, 4, 'Jan 1, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (752, 1, 'Jan 1, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (752, 2, 'Jan 1, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (752, 6, 'Jan 1, 2025', 10)

Insert Into Mode values (7521, 752, 'Y')
Insert Into Mode values (7522, 752, 'H')
Insert Into Mode values (7523, 752, 'Q')
Insert Into Mode values (7524, 752, 'E')

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (752, 'ENG', 'LIC SIIP')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (752, 'MAR', ',y-vk;-lh- lhi')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (752, 'HIN', ',y-vk;-lh- lhi')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (752, 'GUJ', '+.+ɫ.. ~')

Insert into Underwritting values (417, 'Invalid Premium', 'Min Premium allowed is: Yly-42000, Hly-21000, Qly-10500, Mly(NACH)-3500')

Update InsurancePlan Set HighlightColor = '$00FCFBE0' where PlanInternalno = 752
