APPS.CN_QUOTA_RULE_UPLIFT_PVT dependencies on CN_QUOTA_RULES

Line 422: cn_quota_rules qr

418: INTO l_start_date,
419: l_end_date,
420: l_quota_id
421: FROM cn_quotas q,
422: cn_quota_rules qr
423: WHERE qr.quota_rule_id = l_quota_rule_id AND q.quota_id = qr.quota_id;
424:
425: IF (l_rev_uplift_rec_tbl (1).start_date < l_start_date) OR (NVL (l_rev_uplift_rec_tbl (1).end_date, l_null_date) > l_end_date)
426: THEN

Line 442: cn_quota_rules qr

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:
445: cn_quota_rule_uplifts_grp.create_quota_rule_uplift (p_api_version => 1.0,
446: p_init_msg_list => 'T',

Line 664: cn_quota_rules qr

660: INTO l_start_date,
661: l_end_date,
662: l_quota_id
663: FROM cn_quotas q,
664: cn_quota_rules qr
665: WHERE qr.quota_rule_id = l_quota_rule_id AND q.quota_id = qr.quota_id;
666:
667: IF l_old_quota_rule_uplift.object_version_number <> p_quota_rule_uplift.object_version_number
668: THEN

Line 696: cn_quota_rules qr

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:
699: SELECT r.NAME
700: INTO l_rev_uplift_rec_tbl (1).rev_class_name_old

Line 702: cn_quota_rules qr

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,
706: p_init_msg_list => p_init_msg_list,

Line 858: cn_quota_rules qr,

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
861: AND r.revenue_class_id = qr.revenue_class_id
862: AND q.quota_id = qr.quota_id