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 3637: FROM cn_repositories_all

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

Line 4513: FROM cn_repositories_all

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

Line 4587: FROM cn_repositories_all

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

Line 4601: FROM cn_repositories_all

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

Line 4651: FROM cn_repositories_all

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

Line 4661: FROM cn_repositories_all

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