APPS.CN_COMP_PLAN_PVT dependencies on CN_QUOTA_ASSIGNS

Line 561: cn_quota_assigns qa

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);
565:

Line 1445: FROM cn_quota_assigns qa,

1441:
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

Line 1478: FROM cn_quota_assigns

1474:
1475: -- 1. need to have plan element assigned
1476: SELECT COUNT (1)
1477: INTO l_temp_count
1478: FROM cn_quota_assigns
1479: WHERE comp_plan_id = p_comp_plan.comp_plan_id AND ROWNUM = 1;
1480:
1481: IF l_temp_count = 0
1482: THEN

Line 1612: cn_quota_assigns qa,

1608: /* CURSOR check_overlap_curs IS
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

Line 1638: cn_quota_assigns qa,

1634: IS
1635: SELECT COUNT (de.value_external_id),COUNT (distinct de.value_external_id)
1636: FROM cn_dim_explosion de,
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

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

Line 1803: Select * from cn_quota_assigns_all

1799: Where comp_plan_id = p_comp_plan_id
1800: And org_id = p_org_id;
1801:
1802: CURSOR get_quota_assign_data IS
1803: Select * from cn_quota_assigns_all
1804: Where comp_plan_id = p_comp_plan_id;
1805:
1806: l_comp_plan get_comp_plan_data%rowtype;
1807: l_comp_plan_rec comp_plan_rec_type;