APPS.CN_PROC_BATCHES_PKG dependencies on CN_COMMISSION_LINES_ALL

Line 1200: FROM cn_commission_lines_all

1196: AND spa.comp_plan_id = PLAN.comp_plan_id
1197: AND PLAN.status_code = 'COMPLETE')
1198: OR EXISTS(
1199: SELECT 1
1200: FROM cn_commission_lines_all
1201: WHERE credited_salesrep_id = intel.salesrep_id
1202: AND processed_period_id BETWEEN l_calc_from_period_id
1203: AND l_calc_to_period_id
1204: AND org_id = intel.org_id

Line 1279: FROM cn_commission_lines_all

1275: )
1276: OR (
1277: EXISTS(
1278: SELECT 1
1279: FROM cn_commission_lines_all
1280: WHERE credited_salesrep_id = cse.salesrep_id
1281: AND processed_period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1282: AND status <> 'OBSOLETE'
1283: AND org_id = cse.org_id)

Line 1394: FROM cn_commission_lines_all cl, cn_period_statuses_all p

1390: SELECT DISTINCT cl.credited_salesrep_id
1391: , p.start_date
1392: , p.end_date
1393: , p.period_id
1394: FROM cn_commission_lines_all cl, cn_period_statuses_all p
1395: WHERE cl.processed_period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1396: AND cl.status IN('ROLL', 'POP')
1397: AND cl.org_id = g_org_id
1398: AND cl.processed_period_id = p.period_id

Line 1857: FROM cn_commission_lines_all line, cn_process_batches_all batch

1853: ORDER BY salesrep_id DESC;
1854:
1855: CURSOR rep_lines_info(p_salesrep_id NUMBER) IS
1856: SELECT COUNT(1)
1857: FROM cn_commission_lines_all line, cn_process_batches_all batch
1858: WHERE batch.logical_batch_id = g_logical_batch_id
1859: AND batch.salesrep_id = p_salesrep_id
1860: AND batch.status_code = 'IN_USE'
1861: AND line.credited_salesrep_id = p_salesrep_id

Line 1913: FROM cn_commission_lines_all

1909:
1910: UPDATE cn_process_batches_all a
1911: SET a.sales_lines_total =
1912: (SELECT COUNT(1)
1913: FROM cn_commission_lines_all
1914: WHERE credited_salesrep_id = a.salesrep_id
1915: AND org_id = a.org_id
1916: AND processed_period_id BETWEEN a.period_id AND a.end_period_id
1917: AND processed_date BETWEEN a.start_date AND a.end_date)

Line 1934: FROM cn_commission_lines_all

1930: ELSIF((l_batch_info.calc_type = 'COMMISSION') AND(l_srp_batch_size_flag <> 'Y')) THEN
1931: UPDATE cn_process_batches_all a
1932: SET a.sales_lines_total =
1933: (SELECT COUNT(1)
1934: FROM cn_commission_lines_all
1935: WHERE credited_salesrep_id = a.salesrep_id
1936: AND org_id = a.org_id
1937: AND processed_period_id BETWEEN a.period_id AND a.end_period_id
1938: AND processed_date BETWEEN a.start_date AND a.end_date)