APPS.CN_CALC_POPULATE_PVT dependencies on CN_QUOTA_RULES_ALL

Line 282: cn_quota_rules_all qr,

278: nvl(rr.end_date_active, p_end_date), p_end_date) end_date
279: from cn_srp_plan_assigns_all spa,
280: cn_srp_quota_assigns_all sqa,
281: cn_quotas_all q,
282: cn_quota_rules_all qr,
283: cn_dim_hierarchies_all dh,
284: jtf_rs_salesreps jrs,
285: jtf_rs_group_members mem,
286: jtf_rs_role_relations rr

Line 342: cn_quota_rules_all qr,

338: nvl(rr.end_date_active, p_end_date), p_end_date) end_date
339: from cn_srp_plan_assigns_all spa,
340: cn_srp_quota_assigns_all sqa,
341: cn_quotas_all q,
342: cn_quota_rules_all qr,
343: jtf_rs_salesreps jrs,
344: jtf_rs_group_members mem,
345: jtf_rs_role_relations rr
346: where spa.salesrep_id = p_salesrep_id

Line 424: FROM cn_quota_rules_all qr

420: AND ( spa.end_date IS NULL OR spa.end_date >= l_processed_date );
421:
422: CURSOR l_quota_rule_no_hier_csr ( l_quota_id NUMBER, l_revenue_class_id NUMBER ) IS
423: SELECT qr.quota_rule_id
424: FROM cn_quota_rules_all qr
425: WHERE qr.quota_id = l_quota_id
426: AND qr.revenue_class_id = l_revenue_class_id;
427:
428: CURSOR l_quota_rule_hier_csr (l_quota_id NUMBER, l_revenue_class_id NUMBER ) IS

Line 430: FROM cn_quota_rules_all qr,

426: AND qr.revenue_class_id = l_revenue_class_id;
427:
428: CURSOR l_quota_rule_hier_csr (l_quota_id NUMBER, l_revenue_class_id NUMBER ) IS
429: SELECT qr.quota_rule_id
430: FROM cn_quota_rules_all qr,
431: cn_dim_explosion_all de
432: WHERE qr.quota_id = l_quota_id
433: AND de.dim_hierarchy_id = l_dim_hierarchy_id
434: AND de.value_external_id = l_revenue_class_id