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 1907: FROM cn_revenue_classes

1903:
1904: -- Find If Revenue Class exists in the Target System
1905: l_rev_class_name := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RevClsName'),0)));
1906: SELECT COUNT(name) into l_rev_class_name_count
1907: FROM cn_revenue_classes
1908: WHERE name = l_rev_class_name
1909: AND org_id = p_org_id;
1910:
1911: -- Get the Revenue Class Values - Only If Revenue Class exists in the Target System

Line 2040: FROM cn_revenue_classes

2036: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RevClsName'),0)));
2037:
2038: -- Check for Id
2039: SELECT COUNT(name) INTO l_rev_class_name_count
2040: FROM cn_revenue_classes
2041: WHERE name = l_rev_class_name
2042: AND org_id = p_org_id;
2043:
2044:

Line 2154: FROM cn_revenue_classes

2150: -- Find Revenue Class existing in the Target System
2151: l_rev_class_name :=
2152: dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RevClsName'),0)));
2153: SELECT COUNT(name) INTO l_rev_class_name_count
2154: FROM cn_revenue_classes
2155: WHERE name = l_rev_class_name
2156: AND org_id = p_org_id;
2157:
2158: -- Get the Revenue Class Values - Only If Revenue Class exists in the Target System