Delete From BasicPremiumAnnuity Where PlanInternalno in (872)

Insert into TargetCriteria Values (1, 104, 'April 1, 2025', 'March 31, 2026', 1, 1, 1)
Insert into TargetCriteria Values (2, 105, 'April 1, 2025', 'March 31, 2026', 1, 1, 1)
Insert into TargetCriteria Values (3, 106, 'April 1, 2025', 'March 31, 2026', 1, 1, 1)
Insert into TargetCriteria Values (4, 107, 'April 1, 2025', 'March 31, 2026', 1, 1, 1)

insert into TargetCriteriaDetail Values (1, 104, 389, 1, 'LIV', 40)
insert into TargetCriteriaDetail Values (1, 104, 390, 2, 'LIV', 130)
insert into TargetCriteriaDetail Values (1, 104, 391, 2, 'LIF', 600)
insert into TargetCriteriaDetail Values (1, 104, 392, 3, 'RCR', 221000)
insert into TargetCriteriaDetail Values (1, 104, 393, 4, 'FBR', 221000)

insert into TargetCriteriaDetail Values (2, 105, 394, 1, 'LIV', 30)
insert into TargetCriteriaDetail Values (2, 105, 395, 2, 'LIV', 100)
insert into TargetCriteriaDetail Values (2, 105, 396, 2, 'LIF', 400)
insert into TargetCriteriaDetail Values (2, 105, 397, 3, 'RCR', 154000)
insert into TargetCriteriaDetail Values (2, 105, 398, 4, 'FBR', 154000)

insert into TargetCriteriaDetail Values (3, 106, 399, 1, 'LIV', 20)
insert into TargetCriteriaDetail Values (3, 106, 400, 2, 'LIV', 80)
insert into TargetCriteriaDetail Values (3, 106, 401, 2, 'LIF', 250)
insert into TargetCriteriaDetail Values (3, 106, 402, 3, 'RCR', 100000)
insert into TargetCriteriaDetail Values (3, 106, 403, 4, 'FBR', 66000)

insert into TargetCriteriaDetail Values (4, 107, 404, 1, 'LIV', 15)
insert into TargetCriteriaDetail Values (4, 107, 405, 2, 'LIV', 50)
insert into TargetCriteriaDetail Values (4, 107, 406, 2, 'LIF', 150)
insert into TargetCriteriaDetail Values (4, 107, 407, 3, 'RCR', 56000)
insert into TargetCriteriaDetail Values (4, 107, 408, 4, 'FBR', 39000)


Insert into TargetCriteria Values (5, 108, 'Jan 1, 2025', 'Dec 31, 2025', 1, 1, 1)
Insert into TargetCriteria Values (6, 109, 'Jan 1, 2025', 'Dec 31, 2025', 1, 1, 1)
Insert into TargetCriteria Values (7, 110, 'Jan 1, 2025', 'Dec 31, 2025', 1, 1, 1)

insert into TargetCriteriaDetail Values (5, 108, 409, 1, 'FYR', 6795600) -- TOT firstYearCommission = 5253000, firstYearPremium = 21012000
insert into TargetCriteriaDetail Values (5, 108, 410, 1, 'FYP', 27182400)
insert into TargetCriteriaDetail Values (6, 109, 411, 1, 'FYR', 3397800) -- COT firstYearCommission = 2626500, firstYearPremium = 10506000
insert into TargetCriteriaDetail Values (6, 109, 412, 1, 'FYP', 13591200)
insert into TargetCriteriaDetail Values (7, 110, 413, 1, 'FYR', 1132600) -- MDRT firstYearCommission = 875500, firstYearPremium = 3502000
insert into TargetCriteriaDetail Values (7, 110, 414, 1, 'FYP', 4530400)

insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (5, 108, 99, 'P', 'FYP', 10)
insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (6, 109, 100, 'P', 'FYP', 10)
insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (7, 110, 101, 'P', 'FYP', 10)

