eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PROC_BATCHES_PKG dependencies on CN_COMMISSION_HEADERS_ALL

Line 1208: FROM cn_commission_headers_all

1204: AND org_id = intel.org_id
1205: AND processed_date BETWEEN l_start_date AND l_end_date)
1206: OR EXISTS(
1207: SELECT 1
1208: FROM cn_commission_headers_all
1209: WHERE direct_salesrep_id = intel.salesrep_id
1210: AND org_id = intel.org_id
1211: AND processed_date BETWEEN l_start_date AND l_end_date)
1212: );

Line 1288: FROM cn_commission_headers_all

1284: )
1285: OR (
1286: EXISTS(
1287: SELECT 1
1288: FROM cn_commission_headers_all
1289: WHERE direct_salesrep_id = cse.salesrep_id
1290: AND processed_period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1291: AND status <> 'OBSOLETE'
1292: AND org_id = cse.org_id)

Line 1379: FROM cn_commission_headers_all ch

1375: SELECT DISTINCT ch.direct_salesrep_id
1376: , ch.processed_period_id
1377: , ch.processed_date
1378: , NVL(ch.rollup_date, ch.processed_date) rollup_date
1379: FROM cn_commission_headers_all ch
1380: WHERE ch.direct_salesrep_id IN(
1381: SELECT salesrep_id
1382: FROM cn_srp_intel_periods_all
1383: WHERE period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id

Line 1920: FROM cn_commission_headers_all

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)
1918: , a.commission_headers_count =
1919: (SELECT COUNT(1)
1920: FROM cn_commission_headers_all
1921: WHERE direct_salesrep_id = a.salesrep_id
1922: AND org_id = a.org_id
1923: AND processed_period_id BETWEEN a.period_id AND a.end_period_id
1924: AND processed_date BETWEEN a.start_date AND a.end_date)

Line 1941: FROM cn_commission_headers_all

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)
1939: , a.commission_headers_count =
1940: (SELECT COUNT(1)
1941: FROM cn_commission_headers_all
1942: WHERE direct_salesrep_id = a.salesrep_id
1943: AND org_id = a.org_id
1944: AND processed_period_id BETWEEN a.period_id AND a.end_period_id
1945: AND processed_date BETWEEN a.start_date AND a.end_date)

Line 4457: FROM cn_commission_headers_all h

4453: AND start_date <= sip.end_date
4454: AND NVL(end_date, sip.start_date) >= sip.start_date)
4455: AND EXISTS(
4456: SELECT 1
4457: FROM cn_commission_headers_all h
4458: WHERE h.direct_salesrep_id = sip.salesrep_id
4459: AND h.org_id = sip.org_id
4460: AND h.processed_date BETWEEN sip.start_date AND sip.end_date
4461: AND h.trx_type = 'BONUS');

Line 4496: FROM cn_commission_headers_all h

4492: --end of code added for forwardport bug 6600074
4493: )
4494: OR EXISTS(
4495: SELECT 1
4496: FROM cn_commission_headers_all h
4497: WHERE h.direct_salesrep_id = cse.salesrep_id
4498: AND h.processed_date BETWEEN l_start_date AND l_end_date
4499: AND h.org_id = cse.org_id
4500: AND h.trx_type = 'BONUS')

Line 4570: FROM cn_commission_headers_all

4566: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))
4567: ))
4568: OR EXISTS(
4569: SELECT 1
4570: FROM cn_commission_headers_all
4571: WHERE direct_salesrep_id = p_salesrep_id
4572: AND org_id = bat.org_id
4573: AND processed_date BETWEEN period.start_date AND period.end_date
4574: AND trx_type = 'BONUS')