DBA Data[Home] [Help]

APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_RULE_UPLIFTS_ALL

Line 117: , cn_srp_rule_uplifts_all csru

113: FROM cn_srp_quota_assigns_all csqa
114: , cn_quota_rules_all cqr
115: , cn_srp_quota_rules_all csqr
116: , cn_quota_rule_uplifts_all cqru
117: , cn_srp_rule_uplifts_all csru
118: WHERE csqa.srp_quota_assign_id = x_srp_quota_assign_id
119: AND cqr.quota_id = x_quota_id
120: AND csqr.srp_plan_assign_id = csqa.srp_plan_assign_id
121: AND csqr.srp_quota_assign_id = x_srp_quota_assign_id

Line 671: UPDATE cn_srp_rule_uplifts_all srp

667: performance_goal = l_recinfo.performance_goal
668: WHERE srp_quota_rule_id = l_recinfo.srp_quota_rule_id
669: ;
670:
671: UPDATE cn_srp_rule_uplifts_all srp
672: SET (payment_factor, quota_factor)
673: = (SELECT payment_factor, quota_factor
674: FROM cn_quota_rule_uplifts_all q
675: WHERE q.quota_rule_uplift_id = srp.quota_rule_uplift_id)