APPS.CN_CALC_ROLLUP_PVT dependencies on CN_PROCESS_BATCHES_ALL

Line 74: FROM cn_process_batches_all

70: CURSOR intel_calc_flag IS
71: SELECT NVL( intelligent_flag, 'N' )
72: FROM cn_calc_submission_batches_all
73: WHERE logical_batch_id = ( SELECT logical_batch_id
74: FROM cn_process_batches_all
75: WHERE physical_batch_id = p_physical_batch_id AND ROWNUM = 1 );
76:
77: CURSOR sum_trxs IS
78: SELECT ch.direct_salesrep_id, ch.processed_period_id, ch.processed_date

Line 81: FROM cn_commission_headers_all ch, cn_process_batches_all pb

77: CURSOR sum_trxs IS
78: SELECT ch.direct_salesrep_id, ch.processed_period_id, ch.processed_date
79: , NVL( ch.rollup_date, ch.processed_date ), ch.comp_group_id, ch.revenue_class_id, ch.trx_type
80: , SUM( ch.transaction_amount ), SUM( ch.quantity )
81: FROM cn_commission_headers_all ch, cn_process_batches_all pb
82: WHERE pb.physical_batch_id = p_physical_batch_id
83: AND ch.direct_salesrep_id = pb.salesrep_id
84: AND ch.processed_date BETWEEN pb.start_date AND pb.end_date
85: AND ch.org_id = pb.org_id

Line 1271: FROM cn_commission_lines_all cl, cn_process_batches_all pb

1267:
1268: CURSOR l_transactions_cr IS
1269: SELECT cl.commission_header_id commission_header_id, cl.commission_line_id commission_line_id
1270: , cl.credited_salesrep_id credited_salesrep_id
1271: FROM cn_commission_lines_all cl, cn_process_batches_all pb
1272: WHERE pb.physical_batch_id = p_physical_batch_id
1273: AND pb.salesrep_id = cl.credited_salesrep_id
1274: AND cl.org_id = g_org_id
1275: AND cl.processed_period_id BETWEEN pb.period_id AND pb.end_period_id

Line 1374: FROM cn_notify_log_all event, cn_process_batches_all batch

1370: AND event.status = 'INCOMPLETE'
1371: UNION
1372: SELECT event.salesrep_id, event.comp_group_id, event.start_date
1373: , NVL( event.end_date, g_end_of_time ) end_date, event.action, event.notify_log_id
1374: FROM cn_notify_log_all event, cn_process_batches_all batch
1375: WHERE batch.physical_batch_id = p_physical_batch_id
1376: AND batch.salesrep_id = event.salesrep_id
1377: AND event.org_id = g_org_id
1378: AND event.period_id BETWEEN batch.period_id AND batch.end_period_id

Line 1385: FROM cn_process_batches_all

1381: ORDER BY cur.notify_log_id;
1382:
1383: CURSOR l_roll_new_trx_cr IS
1384: SELECT salesrep_id, start_date, end_date
1385: FROM cn_process_batches_all
1386: WHERE physical_batch_id = p_physical_batch_id
1387: ORDER BY process_batch_id;
1388: BEGIN
1389: -- Standard Start of API savepoint

Line 1408: FROM cn_process_batches_all

1404:
1405: -- Codes start here
1406: SELECT org_id
1407: INTO g_org_id
1408: FROM cn_process_batches_all
1409: WHERE physical_batch_id = p_physical_batch_id AND ROWNUM = 1;
1410:
1411: g_mark_event_flag := NVL( fnd_profile.VALUE( 'CN_MARK_EVENTS' ), 'N' );
1412: g_srp_validation_flag := NVL( fnd_profile.VALUE( 'CN_SRP_VALIDATION' ), 'N' );

Line 1432: FROM cn_calc_submission_batches_all cb, cn_process_batches_all pb

1428:
1429: IF p_mode = 'NORMAL' THEN
1430: SELECT cb.logical_batch_id, cb.intelligent_flag
1431: INTO l_log_batch_id, l_is_incremental
1432: FROM cn_calc_submission_batches_all cb, cn_process_batches_all pb
1433: WHERE cb.logical_batch_id = pb.logical_batch_id
1434: AND pb.physical_batch_id = p_physical_batch_id
1435: AND pb.org_id = cb.org_id
1436: AND ROWNUM = 1;