APPS.CN_CALC_POPULATE_PVT dependencies on CN_PROCESS_BATCHES_ALL

Line 214: cn_process_batches_all pb,

210: scg.comp_group_id,
211: greatest(pb.start_date, sct.start_date_active, scg.start_date_active) start_date,
212: least(pb.end_date, nvl(sct.end_date_active, pb.end_date), nvl(scg.end_date_active, pb.end_date)) end_date
213: FROM cn_srp_comp_teams_v sct,
214: cn_process_batches_all pb,
215: cn_srp_comp_groups_v scg
216: WHERE pb.physical_batch_id = p_physical_batch_id
217: AND pb.salesrep_id = sct.salesrep_id
218: AND pb.start_date <= nvl(sct.end_date_active, pb.end_date)

Line 252: cn_process_batches_all pb

248: pb.start_date,
249: pb.end_date,
250: cl.revenue_class_id
251: from cn_commission_lines_all cl,
252: cn_process_batches_all pb
253: where pb.physical_batch_id = p_physical_batch_id
254: and cl.credited_salesrep_id = pb.salesrep_id
255: and cl.processed_period_id between pb.period_id AND pb.end_period_id
256: and cl.processed_date BETWEEN pb.start_date AND pb.end_date

Line 383: cn_process_batches_all pb

379: ch.quota_id,
380: ch.revenue_class_id
381: FROM cn_commission_lines_all cl,
382: cn_commission_headers_all ch,
383: cn_process_batches_all pb
384: WHERE pb.physical_batch_id = p_physical_batch_id
385: AND cl.credited_salesrep_id = pb.salesrep_id
386: AND cl.processed_period_id between pb.period_id AND pb.end_period_id
387: AND cl.processed_date BETWEEN pb.start_date AND pb.end_date

Line 457: from cn_process_batches_all

453: -- Initialize API return status to success
454: x_return_status := FND_API.G_RET_STS_SUCCESS;
455:
456: select org_id into g_org_id
457: from cn_process_batches_all
458: where physical_batch_id = p_physical_batch_id
459: and rownum = 1;
460:
461: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1095: cn_process_batches_all pb

1091: srp_plan_assign_id = NULL
1092: WHERE cl.commission_line_id IN
1093: (SELECT line.commission_line_id
1094: FROM cn_commission_lines_all line,
1095: cn_process_batches_all pb
1096: WHERE pb.physical_batch_id = p_physical_batch_id
1097: AND line.credited_salesrep_id = pb.salesrep_id
1098: AND line.processed_period_id BETWEEN pb.period_id AND pb.end_period_id
1099: AND line.processed_date BETWEEN pb.start_date AND pb.end_date