APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_ACC_PERIOD_STATUSES_V

Line 2382: SELECT COUNT(PERIOD_ID) INTO l_period_exist_count FROM cn_acc_period_statuses_v WHERE ORG_ID=p_org_id and period_id>l_period_id;

2378: IF l_period_name IS NULL THEN
2379:
2380: l_period_id:=l_period_id-1;
2381: l_period_exist_count:=0;
2382: SELECT COUNT(PERIOD_ID) INTO l_period_exist_count FROM cn_acc_period_statuses_v WHERE ORG_ID=p_org_id and period_id>l_period_id;
2383:
2384: IF l_period_exist_count<>0 THEN
2385:
2386: SELECT MIN(PERIOD_ID) INTO l_period_id FROM cn_acc_period_statuses_v WHERE ORG_ID=p_org_id AND period_id>l_period_id;

Line 2386: SELECT MIN(PERIOD_ID) INTO l_period_id FROM cn_acc_period_statuses_v WHERE ORG_ID=p_org_id AND period_id>l_period_id;

2382: SELECT COUNT(PERIOD_ID) INTO l_period_exist_count FROM cn_acc_period_statuses_v WHERE ORG_ID=p_org_id and period_id>l_period_id;
2383:
2384: IF l_period_exist_count<>0 THEN
2385:
2386: SELECT MIN(PERIOD_ID) INTO l_period_id FROM cn_acc_period_statuses_v WHERE ORG_ID=p_org_id AND period_id>l_period_id;
2387: l_period_name := cn_api.get_acc_period_name(l_period_id, p_org_id);
2388:
2389: END IF; --end of l_period_exist_count<>0
2390: