APPS.CN_PROC_BATCHES_PKG dependencies on CN_NOTIFY_LOG_ALL

Line 870: FROM cn_notify_log_all

866: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
867:
868: CURSOR l_affected_all_csr IS
869: SELECT 'Y'
870: FROM cn_notify_log_all
871: WHERE org_id = l_org_id
872: AND salesrep_id = -1000
873: AND period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
874: AND status = 'INCOMPLETE'

Line 1060: FROM cn_notify_log_all

1056: OR srd.org_code = 'EMPTY'
1057: )
1058: AND EXISTS(
1059: SELECT 1
1060: FROM cn_notify_log_all
1061: WHERE salesrep_id = spa.salesrep_id
1062: AND org_id = l_org_id
1063: AND period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1064: AND status = 'INCOMPLETE'

Line 1270: FROM cn_notify_log_all LOG

1266: AND (
1267: (
1268: EXISTS(
1269: SELECT 1
1270: FROM cn_notify_log_all LOG
1271: WHERE LOG.period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1272: AND LOG.status = 'INCOMPLETE'
1273: AND LOG.org_id = cse.org_id
1274: AND (LOG.salesrep_id = -1000 OR LOG.salesrep_id = cse.salesrep_id))

Line 1406: FROM cn_notify_log_all LOG, cn_period_statuses_all period

1402: SELECT DISTINCT LOG.salesrep_id
1403: , period.start_date
1404: , period.end_date
1405: , period.period_id
1406: FROM cn_notify_log_all LOG, cn_period_statuses_all period
1407: WHERE period.period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1408: AND period.org_id = g_org_id
1409: AND LOG.period_id = period.period_id
1410: AND LOG.org_id = g_org_id

Line 1420: , cn_notify_log_all LOG

1416: , period.start_date
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

Line 1868: FROM cn_process_batches_all batch, cn_notify_log_all LOG

1864: AND line.org_id = batch.org_id;
1865:
1866: CURSOR action_links IS
1867: SELECT DISTINCT action_link_id
1868: FROM cn_process_batches_all batch, cn_notify_log_all LOG
1869: WHERE batch.logical_batch_id = g_logical_batch_id
1870: AND batch.status_code = 'IN_USE'
1871: AND LOG.salesrep_id = batch.salesrep_id
1872: AND LOG.period_id BETWEEN batch.period_id AND batch.end_period_id

Line 2034: UPDATE cn_notify_log_all

2030: -- assign the last physical_batch_id to those actions
2031: -- generated from change_srp_hierarchy event
2032: IF (l_batch_info.calc_type = 'COMMISSION' AND l_batch_info.intelligent_flag = 'Y') THEN
2033: FOR action_link IN action_links LOOP
2034: UPDATE cn_notify_log_all
2035: SET physical_batch_id = x_physical_batch_id
2036: WHERE notify_log_id = action_link.action_link_id AND status = 'INCOMPLETE';
2037:
2038: UPDATE cn_notify_log_all

Line 2038: UPDATE cn_notify_log_all

2034: UPDATE cn_notify_log_all
2035: SET physical_batch_id = x_physical_batch_id
2036: WHERE notify_log_id = action_link.action_link_id AND status = 'INCOMPLETE';
2037:
2038: UPDATE cn_notify_log_all
2039: SET physical_batch_id = x_physical_batch_id
2040: WHERE action_link_id = action_link.action_link_id AND status = 'INCOMPLETE';
2041: END LOOP;
2042: END IF;