APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_REVENUE_CLASSES

Line 230: l_rev_class_name cn_revenue_classes.name%TYPE;

226: l_perf_measure_name cn_calc_sql_exps.name%TYPE;
227: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
228: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
229: l_pmt_group_code NUMBER;
230: l_rev_class_name cn_revenue_classes.name%TYPE;
231: l_uplift_start_date DATE;
232: l_uplift_end_date DATE;
233:
234: l_reuse_count NUMBER;

Line 1699: FROM cn_revenue_classes

1695:
1696: -- Find If Revenue Class exists in the Target System
1697: l_rev_class_name := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RevClsName'),0)));
1698: SELECT COUNT(name) into l_rev_class_name_count
1699: FROM cn_revenue_classes
1700: WHERE name = l_rev_class_name
1701: AND org_id = p_org_id;
1702:
1703: -- Get the Revenue Class Values - Only If Revenue Class exists in the Target System

Line 1794: FROM cn_revenue_classes

1790: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RevClsName'),0)));
1791:
1792: -- Check for Id
1793: SELECT COUNT(name) INTO l_rev_class_name_count
1794: FROM cn_revenue_classes
1795: WHERE name = l_rev_class_name
1796: AND org_id = p_org_id;
1797:
1798: -- Uplift Factors start date and end date should fall inside Plan Element date range.

Line 1890: FROM cn_revenue_classes

1886: -- Find Revenue Class existing in the Target System
1887: l_rev_class_name :=
1888: dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RevClsName'),0)));
1889: SELECT COUNT(name) INTO l_rev_class_name_count
1890: FROM cn_revenue_classes
1891: WHERE name = l_rev_class_name
1892: AND org_id = p_org_id;
1893:
1894: -- Get the Revenue Class Values - Only If Revenue Class exists in the Target System