APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_QUOTA_RULES

Line 1768: FROM cn_quota_rules

1764: IF p_plan_element.addup_from_rev_class_flag = 'Y'
1765: THEN
1766: SELECT SUM (target)
1767: INTO p_plan_element.target
1768: FROM cn_quota_rules
1769: WHERE quota_id = p_plan_element.quota_id;
1770:
1771: SELECT SUM (payment_amount)
1772: INTO p_plan_element.payment_amount

Line 1773: FROM cn_quota_rules

1769: WHERE quota_id = p_plan_element.quota_id;
1770:
1771: SELECT SUM (payment_amount)
1772: INTO p_plan_element.payment_amount
1773: FROM cn_quota_rules
1774: WHERE quota_id = p_plan_element.quota_id;
1775:
1776: SELECT SUM (performance_goal)
1777: INTO p_plan_element.performance_goal

Line 1778: FROM cn_quota_rules

1774: WHERE quota_id = p_plan_element.quota_id;
1775:
1776: SELECT SUM (performance_goal)
1777: INTO p_plan_element.performance_goal
1778: FROM cn_quota_rules
1779: WHERE quota_id = p_plan_element.quota_id;
1780: END IF;
1781:
1782: -- update the accounts data

Line 2167: cn_quota_rules qr

2163: 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)
2164: IS
2165: SELECT COUNT (1)
2166: FROM cn_quota_rule_uplifts qru,
2167: cn_quota_rules qr
2168: WHERE qr.quota_id = p_quota_id
2169: AND qr.quota_rule_id = qru.quota_rule_id
2170: 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);
2171:

Line 2631: cn_quota_rules_all qr,

2627: qr.revenue_class_id,
2628: rc.NAME rev_class_name,
2629: q.quota_type_code
2630: FROM cn_quotas q,
2631: cn_quota_rules_all qr,
2632: cn_revenue_classes_all rc
2633: WHERE qr.quota_id = p_quota_id
2634: AND qr.revenue_class_id = rc.revenue_class_id
2635: AND q.quota_id = qr.quota_id