APPS.CN_COMP_PLAN_PVT dependencies on CN_QUOTAS_V

Line 560: FROM cn_quotas_v q,

556: -- check plan element assignments - they just have to intersect
557: -- role, salesrep assignments have to be contained with in comp plan range
558: SELECT COUNT (1)
559: INTO l_temp_count
560: FROM cn_quotas_v q,
561: cn_quota_assigns qa
562: WHERE q.quota_id = qa.quota_id
563: AND qa.comp_plan_id = l_comp_plan_id
564: AND GREATEST (start_date, l_start_date) > LEAST (NVL (end_date, l_end_date), l_end_date);

Line 1446: cn_quotas_v q,

1442: CURSOR incomp_formulas
1443: IS
1444: SELECT f.NAME
1445: FROM cn_quota_assigns qa,
1446: cn_quotas_v q,
1447: cn_calc_formulas f
1448: WHERE qa.comp_plan_id = p_comp_plan.comp_plan_id
1449: AND q.quota_id = qa.quota_id
1450: AND q.calc_formula_id = f.calc_formula_id

Line 1613: cn_quotas_v q,

1609: SELECT count(value_external_id), count( distinct value_external_id)
1610: FROM cn_dim_explosion de,
1611: cn_quota_rules qr,
1612: cn_quota_assigns qa,
1613: cn_quotas_v q,
1614: cn_dim_hier_periods dh,
1615: cn_periods cp
1616: WHERE dh.header_hierarchy_id = cn_global_var.g_rev_class_hierarchy_id
1617: AND cp.start_date >= q.start_date

Line 1641: from cn_quotas_v q1, cn_quota_assigns qa

1637: cn_quota_rules qr,
1638: cn_quota_assigns qa,
1639:
1640: (select q1.quota_id, q1.start_date, q1.end_Date
1641: from cn_quotas_v q1, cn_quota_assigns qa
1642: where
1643: qa.comp_plan_id = p_comp_plan_id
1644: and qa.quota_id = q1.quota_id
1645: and exists

Line 1647: select 1 from cn_quotas_v q2, cn_quota_assigns qa1

1643: qa.comp_plan_id = p_comp_plan_id
1644: and qa.quota_id = q1.quota_id
1645: and exists
1646: (
1647: select 1 from cn_quotas_v q2, cn_quota_assigns qa1
1648: where
1649: qa1.comp_plan_id = p_comp_plan_id
1650: and qa1.quota_id = q2.quota_id
1651: and q1.quota_id <> q2.quota_id