DBA Data[Home] [Help]

APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_QUOTA_RULE_UPLIFTS_ALL

Line 116: , cn_quota_rule_uplifts_all cqru

112: SELECT 'X'
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

Line 674: FROM cn_quota_rule_uplifts_all q

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)
676: WHERE srp.srp_quota_rule_id = l_recinfo.srp_quota_rule_id
677: ;
678: