DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_QUOTA_RULES_ALL

Line 3756: FROM cn_srp_quota_rules_all sqr,

3752: UPDATE cn_commission_lines_all cl
3753: SET (payment_factor,quota_factor) =
3754: (SELECT squ.payment_factor/100,
3755: squ.quota_factor/100
3756: FROM cn_srp_quota_rules_all sqr,
3757: cn_srp_rule_uplifts_all squ,
3758: cn_quota_rule_uplifts_all qru
3759: WHERE sqr.srp_plan_assign_id = cl.srp_plan_assign_id
3760: AND sqr.quota_rule_id = cl.quota_rule_id