110: FROM
111: (
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
570: SELECT qr.target,
571: qr.payment_amount,
572: qr.performance_goal,
573: sqr.srp_quota_rule_id
574: FROM cn_quota_rules_all qr,
575: cn_srp_quota_rules_all sqr
576: WHERE qr.quota_rule_id = sqr.quota_rule_id
577: AND sqr.srp_quota_assign_id = x_srp_quota_assign_id
578: ;