APPS.CN_COMP_PLAN_PVT dependencies on CN_QUOTA_ASSIGNS

Line 569: cn_quota_assigns qa

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

Line 1457: FROM cn_quota_assigns qa,

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

Line 1490: FROM cn_quota_assigns

1486:
1487: -- 1. need to have plan element assigned
1488: SELECT COUNT (1)
1489: INTO l_temp_count
1490: FROM cn_quota_assigns
1491: WHERE comp_plan_id = p_comp_plan.comp_plan_id AND ROWNUM = 1;
1492:
1493: IF l_temp_count = 0
1494: THEN

Line 1628: cn_quota_assigns qa,

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

Line 1654: cn_quota_assigns qa,

1650: IS
1651: SELECT COUNT (de.value_external_id),COUNT (distinct de.value_external_id)
1652: FROM cn_dim_explosion de,
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

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

Line 1821: Select * from cn_quota_assigns_all

1817: Where comp_plan_id = p_comp_plan_id
1818: And org_id = p_org_id;
1819:
1820: CURSOR get_quota_assign_data IS
1821: Select * from cn_quota_assigns_all
1822: Where comp_plan_id = p_comp_plan_id
1823: order by quota_sequence asc;
1824:
1825: l_comp_plan get_comp_plan_data%rowtype;