Update CombinationPlan Set InUse = 0 Where CombinationPlanInternalno in (10, 14)
Update InsurancePlan Set MinSa = 10000 Where PlanInternalno = 109
Update InsurancePlan Set MinSa = 75000 Where PlanInternalno = 943
update CommissionRate Set ToTerm = 99 where PlanInternalno = 934 and FromTerm = 15 and Toterm = 19
Insert into TargetCriteria Values (5, 104, 'Jan 1, 2025', 'Dec 31, 2025', 1, 1, 1)
Insert into TargetCriteria Values (6, 105, 'Jan 1, 2025', 'Dec 31, 2025', 1, 1, 1)
Insert into TargetCriteria Values (7, 106, 'Jan 1, 2025', 'Dec 31, 2025', 1, 1, 1)

insert into TargetCriteriaDetail Values (5, 104, 389, 1, 'FYR', 6795600) -- TOT firstYearCommission = 5253000, firstYearPremium = 21012000
insert into TargetCriteriaDetail Values (5, 104, 390, 1, 'FYP', 27182400)
insert into TargetCriteriaDetail Values (6, 105, 391, 1, 'FYR', 3397800) -- COT firstYearCommission = 2626500, firstYearPremium = 10506000
insert into TargetCriteriaDetail Values (6, 105, 392, 1, 'FYP', 13591200)
insert into TargetCriteriaDetail Values (7, 106, 393, 1, 'FYR', 1132600) -- MDRT firstYearCommission = 875500, firstYearPremium = 3502000
insert into TargetCriteriaDetail Values (7, 106, 394, 1, 'FYP', 4530400)

insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (5, 104, 52, 'P', 'FYP', 10)
insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (6, 105, 53, 'P', 'FYP', 10)
insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (7, 106, 54, 'P', 'FYP', 10)

