APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_QUOTA_RULES

Line 1744: FROM cn_quota_rules

1740: IF p_plan_element.addup_from_rev_class_flag = 'Y'
1741: THEN
1742: SELECT SUM (target)
1743: INTO p_plan_element.target
1744: FROM cn_quota_rules
1745: WHERE quota_id = p_plan_element.quota_id;
1746:
1747: SELECT SUM (payment_amount)
1748: INTO p_plan_element.payment_amount

Line 1749: FROM cn_quota_rules

1745: WHERE quota_id = p_plan_element.quota_id;
1746:
1747: SELECT SUM (payment_amount)
1748: INTO p_plan_element.payment_amount
1749: FROM cn_quota_rules
1750: WHERE quota_id = p_plan_element.quota_id;
1751:
1752: SELECT SUM (performance_goal)
1753: INTO p_plan_element.performance_goal

Line 1754: FROM cn_quota_rules

1750: WHERE quota_id = p_plan_element.quota_id;
1751:
1752: SELECT SUM (performance_goal)
1753: INTO p_plan_element.performance_goal
1754: FROM cn_quota_rules
1755: WHERE quota_id = p_plan_element.quota_id;
1756: END IF;
1757:
1758: -- update the accounts data

Line 2143: cn_quota_rules qr

2139: CURSOR uplift_curs(p_quota_id cn_quotas.quota_id%TYPE, p_start_date cn_quotas.start_date%TYPE, p_end_date cn_quotas.end_date%TYPE)
2140: IS
2141: SELECT COUNT (1)
2142: FROM cn_quota_rule_uplifts qru,
2143: cn_quota_rules qr
2144: WHERE qr.quota_id = p_quota_id
2145: AND qr.quota_rule_id = qru.quota_rule_id
2146: AND (qru.start_date < p_start_date OR (p_end_date IS NOT NULL AND qru.end_date IS NULL) OR qru.end_date > p_end_date);
2147:

Line 2607: cn_quota_rules_all qr,

2603: qr.revenue_class_id,
2604: rc.NAME rev_class_name,
2605: q.quota_type_code
2606: FROM cn_quotas q,
2607: cn_quota_rules_all qr,
2608: cn_revenue_classes_all rc
2609: WHERE qr.quota_id = p_quota_id
2610: AND qr.revenue_class_id = rc.revenue_class_id
2611: AND q.quota_id = qr.quota_id