APPS.CN_QUOTA_RULE_UPLIFT_PVT dependencies on CN_REVENUE_CLASSES

Line 440: FROM cn_revenue_classes r,

436: SELECT r.NAME,
437: q.NAME
438: INTO l_rev_uplift_rec_tbl (1).rev_class_name,
439: l_quota_name
440: FROM cn_revenue_classes r,
441: cn_quotas q,
442: cn_quota_rules qr
443: WHERE qr.quota_rule_id = l_quota_rule_id AND r.revenue_class_id = qr.revenue_class_id AND q.quota_id = qr.quota_id;
444:

Line 694: FROM cn_revenue_classes r,

690: SELECT r.NAME,
691: q.NAME
692: INTO l_rev_uplift_rec_tbl (1).rev_class_name,
693: l_quota_name
694: FROM cn_revenue_classes r,
695: cn_quotas q,
696: cn_quota_rules qr
697: WHERE qr.quota_rule_id = l_quota_rule_id AND r.revenue_class_id = qr.revenue_class_id AND q.quota_id = qr.quota_id;
698:

Line 701: FROM cn_revenue_classes r,

697: WHERE qr.quota_rule_id = l_quota_rule_id AND r.revenue_class_id = qr.revenue_class_id AND q.quota_id = qr.quota_id;
698:
699: SELECT r.NAME
700: INTO l_rev_uplift_rec_tbl (1).rev_class_name_old
701: FROM cn_revenue_classes r,
702: cn_quota_rules qr
703: WHERE qr.quota_rule_id = l_old_quota_rule_uplift.quota_rule_id AND r.revenue_class_id = qr.revenue_class_id;
704:
705: cn_quota_rule_uplifts_grp.update_quota_rule_uplift (p_api_version => p_api_version,

Line 856: FROM cn_revenue_classes r,

852: l_rev_uplift_rec_tbl (1).start_date,
853: l_rev_uplift_rec_tbl (1).end_date,
854: l_rev_uplift_rec_tbl (1).org_id,
855: l_quota_id
856: FROM cn_revenue_classes r,
857: cn_quotas q,
858: cn_quota_rules qr,
859: cn_quota_rule_uplifts qru
860: WHERE qr.quota_rule_id = qru.quota_rule_id