delete from commissionrate where PlanInternalno = 873

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87301, 10, 99, 1, 1,  'Y', 2.5, 0.40, 1, 71999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87302, 10, 99, 1, 1,  'Y', 4.0, 0.40, 72000, 95999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87303, 10, 99, 1, 1,  'Y', 5.25, 0.40, 96000, 119999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87304, 10, 99, 1, 1,  'Y', 5.75, 0.40, 120000, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87305, 10, 99, 2, 3,  'Y', 3.5, 0.00, 1, 71999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87306, 10, 99, 2, 3,  'Y', 4.5, 0.00, 72000, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87307, 10, 99, 4, 99,  'Y', 4.5, 0.00, 1, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87311, 10, 99, 1, 1,  'H', 2.5, 0.40, 1, 71999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87312, 10, 99, 1, 1,  'H', 4.0, 0.40, 72000, 95999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87313, 10, 99, 1, 1,  'H', 5.25, 0.40, 96000, 119999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87314, 10, 99, 1, 1,  'H', 5.75, 0.40, 120000, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87315, 10, 99, 2, 3,  'H', 3.5, 0.00, 1, 71999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87316, 10, 99, 2, 3,  'H', 4.5, 0.00, 72000, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87317, 10, 99, 4, 99,  'H', 4.5, 0.00, 1, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87321, 10, 99, 1, 1,  'Q', 2.5, 0.40, 1, 71999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87322, 10, 99, 1, 1,  'Q', 4.0, 0.40, 72000, 95999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87323, 10, 99, 1, 1,  'Q', 5.25, 0.40, 96000, 119999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87324, 10, 99, 1, 1,  'Q', 5.75, 0.40, 120000, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87325, 10, 99, 2, 3,  'Q', 3.5, 0.00, 1, 71999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87326, 10, 99, 2, 3,  'Q', 4.5, 0.00, 72000, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87327, 10, 99, 4, 99,  'Q', 4.5, 0.00, 1, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87331, 10, 99, 1, 1,  'E', 2.5, 0.40, 1, 71999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87332, 10, 99, 1, 1,  'E', 4.0, 0.40, 72000, 95999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87333, 10, 99, 1, 1,  'E', 5.25, 0.40, 96000, 119999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87334, 10, 99, 1, 1,  'E', 5.75, 0.40, 120000, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87335, 10, 99, 2, 3,  'E', 3.5, 0.00, 1, 71999)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87336, 10, 99, 2, 3,  'E', 4.5, 0.00, 72000, 2147483647)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate, FromPremium, ToPremium)
Values (873, 87337, 10, 99, 4, 99,  'E', 4.5, 0.00, 1, 2147483647)

