APPS.CN_COMP_PLAN_PVT dependencies on CN_QUOTAS_V

Line 568: FROM cn_quotas_v q,

564: -- check plan element assignments - they just have to intersect
565: -- role, salesrep assignments have to be contained with in comp plan range
566: SELECT COUNT (1)
567: INTO l_temp_count
568: FROM cn_quotas_v q,
569: cn_quota_assigns qa
570: WHERE q.quota_id = qa.quota_id
571: AND qa.comp_plan_id = l_comp_plan_id
572: AND GREATEST (start_date, l_start_date) > LEAST (NVL (end_date, l_end_date), l_end_date);

Line 1458: cn_quotas_v q,

1454: CURSOR incomp_formulas
1455: IS
1456: SELECT f.NAME
1457: FROM cn_quota_assigns qa,
1458: cn_quotas_v q,
1459: cn_calc_formulas f
1460: WHERE qa.comp_plan_id = p_comp_plan.comp_plan_id
1461: AND q.quota_id = qa.quota_id
1462: AND q.calc_formula_id = f.calc_formula_id

Line 1629: cn_quotas_v q,

1625: SELECT count(value_external_id), count( distinct value_external_id)
1626: FROM cn_dim_explosion de,
1627: cn_quota_rules qr,
1628: cn_quota_assigns qa,
1629: cn_quotas_v q,
1630: cn_dim_hier_periods dh,
1631: cn_periods cp
1632: WHERE dh.header_hierarchy_id = cn_global_var.g_rev_class_hierarchy_id
1633: AND cp.start_date >= q.start_date

Line 1657: from cn_quotas_v q1, cn_quota_assigns qa

1653: cn_quota_rules qr,
1654: cn_quota_assigns qa,
1655:
1656: (select q1.quota_id, q1.start_date, q1.end_Date
1657: from cn_quotas_v q1, cn_quota_assigns qa
1658: where
1659: qa.comp_plan_id = p_comp_plan_id
1660: and qa.quota_id = q1.quota_id
1661: and exists

Line 1663: select 1 from cn_quotas_v q2, cn_quota_assigns qa1

1659: qa.comp_plan_id = p_comp_plan_id
1660: and qa.quota_id = q1.quota_id
1661: and exists
1662: (
1663: select 1 from cn_quotas_v q2, cn_quota_assigns qa1
1664: where
1665: qa1.comp_plan_id = p_comp_plan_id
1666: and qa1.quota_id = q2.quota_id
1667: and q1.quota_id <> q2.quota_id