APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_PERIOD_STATUSES

Line 291: l_period_name cn_period_statuses.period_name%TYPE;

287: l_liab_account_id NUMBER;
288: l_expense_account_id NUMBER;
289: l_ee_piped_sql_from CLOB;
290:
291: l_period_name cn_period_statuses.period_name%TYPE;
292: l_period_exist_count NUMBER;
293: l_period_end_date DATE;
294: l_exp_name_source cn_calc_sql_exps.name%TYPE;
295:

Line 2042: FROM cn_period_statuses

2038: -- Checking Period Status and Period Range
2039: l_period_name := NULL;
2040: l_period_name := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'PeriodName'),0)));
2041: SELECT count(period_name) INTO l_period_exist_count
2042: FROM cn_period_statuses
2043: WHERE period_name = l_period_name
2044: AND org_id = p_org_id;
2045:
2046: IF l_period_exist_count <> 0 THEN

Line 2048: FROM cn_period_statuses

2044: AND org_id = p_org_id;
2045:
2046: IF l_period_exist_count <> 0 THEN
2047: SELECT end_date INTO l_period_end_date
2048: FROM cn_period_statuses
2049: WHERE period_name = l_period_name
2050: AND org_id = p_org_id;
2051:
2052: IF p_end_date IS NULL AND NVL(v_plan_element_rec.end_date,l_period_end_date) >= l_period_end_date THEN