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 3646: UPDATE cn_srp_intel_periods_all

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

Line 4443: FROM cn_srp_intel_periods_all sip

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