APPS.CN_PROC_BATCHES_PKG dependencies on CN_REPOSITORIES_ALL

Line 237: FROM cn_repositories_all

233: CURSOR l_dim_hierarchy_csr(l_start_date DATE, l_end_date DATE) IS
234: SELECT dim_hierarchy_id
235: FROM cn_dim_hierarchies_all
236: WHERE header_dim_hierarchy_id = (SELECT rev_class_hierarchy_id
237: FROM cn_repositories_all
238: WHERE org_id = g_org_id)
239: AND org_id = g_org_id
240: AND (
241: (start_date < l_start_date AND(end_date IS NULL OR l_start_date <= end_date))

Line 1434: FROM cn_repositories_all

1430: AND intel.org_id = g_org_id;
1431: BEGIN
1432: SELECT NVL(srp_rollup_flag, 'N')
1433: INTO l_system_rollup_flag
1434: FROM cn_repositories_all
1435: WHERE org_id = g_org_id;
1436:
1437: FOR missed_line IN missed_lines LOOP
1438: cn_mark_events_pkg.mark_notify(

Line 3636: FROM cn_repositories_all

3632: SELECT period_set_id
3633: , period_type_id
3634: INTO l_period_set_id
3635: , l_period_type_id
3636: FROM cn_repositories_all
3637: WHERE org_id = l_org_id;
3638:
3639: SELECT MAX(period_id)
3640: , MAX(end_period_id)

Line 4512: FROM cn_repositories_all

4508: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4509: AND period.org_id = bat.org_id
4510: AND (period.period_set_id, period.period_type_id) = (SELECT period_set_id
4511: , period_type_id
4512: FROM cn_repositories_all
4513: WHERE org_id = bat.org_id)
4514: AND period.end_date BETWEEN bat.start_date AND bat.end_date
4515: AND (
4516: EXISTS -- on period.end_date there is an active comp_plan

Line 4586: FROM cn_repositories_all

4582: AND period.end_date BETWEEN bat.start_date AND bat.end_date
4583: AND (period.period_set_id, period.period_type_id) =
4584: (SELECT period_set_id
4585: , period_type_id
4586: FROM cn_repositories_all
4587: WHERE org_id = bat.org_id)
4588: GROUP BY period.quarter_num;
4589:
4590: CURSOR l_year_int_periods_csr(l_salesrep_id NUMBER) IS

Line 4600: FROM cn_repositories_all

4596: AND period.end_date BETWEEN bat.start_date AND bat.end_date
4597: AND (period.period_set_id, period.period_type_id) =
4598: (SELECT period_set_id
4599: , period_type_id
4600: FROM cn_repositories_all
4601: WHERE org_id = bat.org_id)
4602: GROUP BY period.period_year;
4603:
4604: CURSOR l_period_info_csr(l_period_id NUMBER) IS

Line 4650: FROM cn_repositories_all

4646: WHERE l_start_date BETWEEN start_date AND end_date
4647: AND org_id = l_org_id
4648: AND (period_set_id, period_type_id) = (SELECT period_set_id
4649: , period_type_id
4650: FROM cn_repositories_all
4651: WHERE org_id = l_org_id);
4652:
4653: SELECT period_id
4654: INTO l_end_period_id

Line 4660: FROM cn_repositories_all

4656: WHERE l_end_date BETWEEN start_date AND end_date
4657: AND org_id = l_org_id
4658: AND (period_set_id, period_type_id) = (SELECT period_set_id
4659: , period_type_id
4660: FROM cn_repositories_all
4661: WHERE org_id = l_org_id);
4662:
4663: IF l_salesrep_option = 'ALL_REPS' THEN
4664: IF l_interval_type_id = -1000 OR l_interval_type_id = -1003 THEN