[Home] [Help]
3723: UPDATE cn_commission_lines_all cl
3724: SET (payment_factor,quota_factor) =
3725: (SELECT squ.payment_factor/100,
3726: squ.quota_factor/100
3727: FROM cn_srp_quota_rules_all sqr,
3728: cn_srp_rule_uplifts_all squ,
3729: cn_quota_rule_uplifts_all qru
3730: WHERE sqr.srp_plan_assign_id = cl.srp_plan_assign_id
3731: AND sqr.quota_rule_id = cl.quota_rule_id