APPS.CN_PROC_BATCHES_PKG dependencies on CN_SRP_INTEL_PERIODS_ALL

Line 1177: FROM cn_srp_intel_periods_all intel

1173: IF l_salesrep_option = 'ALL_REPS' THEN
1174: DECLARE
1175: CURSOR l_all_reps_csr(l_start_date DATE, l_end_date DATE) IS
1176: SELECT DISTINCT intel.salesrep_id
1177: FROM cn_srp_intel_periods_all intel
1178: WHERE org_id = l_org_id
1179: AND intel.period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1180: AND (
1181: EXISTS(

Line 1382: FROM cn_srp_intel_periods_all

1378: , NVL(ch.rollup_date, ch.processed_date) rollup_date
1379: FROM cn_commission_headers_all ch
1380: WHERE ch.direct_salesrep_id IN(
1381: SELECT salesrep_id
1382: FROM cn_srp_intel_periods_all
1383: WHERE period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1384: AND org_id = g_org_id)
1385: AND ch.org_id = g_org_id
1386: AND ch.processed_date BETWEEN l_start_date_adj AND l_end_date_adj

Line 1421: , cn_srp_intel_periods_all intel

1417: , period.end_date
1418: , period.period_id
1419: FROM cn_period_statuses_all period
1420: , cn_notify_log_all LOG
1421: , cn_srp_intel_periods_all intel
1422: WHERE period.period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1423: AND period.org_id = g_org_id
1424: AND LOG.period_id = period.period_id
1425: AND LOG.org_id = g_org_id

Line 3647: UPDATE cn_srp_intel_periods_all

3643: , l_calc_to_period_id
3644: FROM cn_process_batches_all
3645: WHERE physical_batch_id = p_physical_batch_id;
3646:
3647: UPDATE cn_srp_intel_periods_all
3648: SET processing_status_code =
3649: DECODE(
3650: p_physical_process
3651: , g_revert, g_reverted

Line 4444: FROM cn_srp_intel_periods_all sip

4440: LEAST(bat.end_date, NVL(b.end_date, bat.end_date)))
4441: --end of code added for forwardport bug 6600074
4442: UNION
4443: SELECT salesrep_id
4444: FROM cn_srp_intel_periods_all sip
4445: WHERE period_id BETWEEN l_start_period_id AND l_end_period_id
4446: AND org_id = l_org_id
4447: AND processing_status_code <> 'CLEAN'
4448: AND NOT EXISTS(