APPS.CN_AGGRT_TRX_PKG dependencies on CN_COMMISSION_HEADERS_ALL

Line 61: from cn_commission_headers_all ch,

57: ch.revenue_class_id,
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

Line 88: insert into cn_commission_headers_all

84: close sum_trxs;
85:
86: IF rep_ids.count > 0 THEN
87: forall i in rep_ids.first..rep_ids.last
88: insert into cn_commission_headers_all
89: (commission_header_id,
90: direct_salesrep_id,
91: processed_date,
92: processed_period_id,

Line 125: UPDATE cn_commission_headers_all

121: l_org_id)
122: returning commission_header_id bulk collect INTO header_ids;
123:
124: forall i IN rep_ids.first..rep_ids.last
125: UPDATE cn_commission_headers_all
126: SET parent_header_id = header_ids(i),
127: -- clku, update the last updated info
128: last_update_date = G_LAST_UPDATE_DATE,
129: last_updated_by = G_LAST_UPDATED_BY,