APPS.CN_AGGRT_TRX_PKG dependencies on CN_PROCESS_BATCHES_ALL

Line 48: FROM cn_process_batches_all

44: CURSOR intel_calc_flag IS
45: SELECT nvl(intelligent_flag, 'N'), org_id
46: FROM cn_calc_submission_batches_all
47: WHERE logical_batch_id = (SELECT logical_batch_id
48: FROM cn_process_batches_all
49: WHERE physical_batch_id = p_physical_batch_id AND ROWNUM = 1);
50:
51: cursor sum_trxs is
52: select ch.direct_salesrep_id,

Line 62: cn_process_batches_all pb

58: ch.trx_type,
59: sum(ch.transaction_amount),
60: sum(ch.quantity)
61: from cn_commission_headers_all ch,
62: cn_process_batches_all pb
63: WHERE pb.physical_batch_id = p_physical_batch_id
64: AND ch.direct_salesrep_id = pb.salesrep_id
65: AND ch.org_id = pb.org_id
66: AND ch.processed_date BETWEEN pb.start_date AND pb.end_date