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_PERIOD_STATUSES_ALL

Line 809: FROM cn_period_statuses_all period

805: CURSOR l_period_csr(l_date DATE) IS
806: SELECT period.period_id
807: , period.start_date
808: , period.end_date
809: FROM cn_period_statuses_all period
810: WHERE l_date BETWEEN period.start_date AND period.end_date AND org_id = p_org_id;
811:
812: dummy DATE;
813: BEGIN

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 1406: FROM cn_notify_log_all LOG, cn_period_statuses_all period

1402: SELECT DISTINCT LOG.salesrep_id
1403: , period.start_date
1404: , period.end_date
1405: , period.period_id
1406: FROM cn_notify_log_all LOG, cn_period_statuses_all period
1407: WHERE period.period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1408: AND period.org_id = g_org_id
1409: AND LOG.period_id = period.period_id
1410: AND LOG.org_id = g_org_id

Line 1419: FROM cn_period_statuses_all period

1415: SELECT DISTINCT intel.salesrep_id
1416: , period.start_date
1417: , period.end_date
1418: , period.period_id
1419: FROM cn_period_statuses_all period
1420: , cn_notify_log_all LOG
1421: , cn_srp_intel_periods_all intel
1422: WHERE period.period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1423: AND period.org_id = g_org_id

Line 3660: FROM cn_process_batches_all batch, cn_period_statuses_all per

3656: )
3657: WHERE (salesrep_id, period_id) IN(
3658: SELECT batch.salesrep_id
3659: , per.period_id
3660: FROM cn_process_batches_all batch, cn_period_statuses_all per
3661: WHERE batch.physical_batch_id = p_physical_batch_id
3662: AND per.period_id BETWEEN batch.period_id AND batch.end_period_id
3663: AND per.org_id = batch.org_id
3664: AND per.period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id

Line 4261: FROM cn_period_statuses_all

4257: BEGIN
4258: IF x_period_id IS NOT NULL THEN
4259: SELECT period_name
4260: INTO x_period_name
4261: FROM cn_period_statuses_all
4262: WHERE period_id = x_period_id AND org_id = p_org_id;
4263:
4264: RETURN x_period_name;
4265: END IF;

Line 4300: FROM cn_period_statuses_all ps1, cn_period_statuses_all ps2

4296: l_end_period_id NUMBER(15);
4297: BEGIN
4298: SELECT MAX(ps2.period_id)
4299: INTO l_end_period_id
4300: FROM cn_period_statuses_all ps1, cn_period_statuses_all ps2
4301: WHERE ps1.org_id = p_org_id
4302: AND ps1.period_id = p_period_id
4303: AND ps2.period_set_id = ps1.period_set_id
4304: AND ps2.period_type_id = ps1.period_type_id

Line 4507: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

4503: CURSOR l_period_int_periods_csr(p_salesrep_id NUMBER, p_interval_type_id NUMBER) IS
4504: SELECT period.period_id
4505: , period.start_date
4506: , period.end_date
4507: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat
4508: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4509: AND period.org_id = bat.org_id
4510: AND (period.period_set_id, period.period_type_id) = (SELECT period_set_id
4511: , period_type_id

Line 4579: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

4575:
4576: CURSOR l_quarter_int_periods_csr(l_salesrep_id NUMBER) IS
4577: SELECT MIN(period.period_id) min_period_id
4578: , MAX(period.period_id) max_period_id
4579: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat
4580: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4581: AND period.org_id = bat.org_id
4582: AND period.end_date BETWEEN bat.start_date AND bat.end_date
4583: AND (period.period_set_id, period.period_type_id) =

Line 4593: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

4589:
4590: CURSOR l_year_int_periods_csr(l_salesrep_id NUMBER) IS
4591: SELECT MIN(period.period_id) min_period_id
4592: , MAX(period.period_id) max_period_id
4593: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat
4594: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4595: AND period.org_id = bat.org_id
4596: AND period.end_date BETWEEN bat.start_date AND bat.end_date
4597: AND (period.period_set_id, period.period_type_id) =

Line 4612: FROM cn_period_statuses_all period

4608: , period.period_set_id
4609: , period.period_type_id
4610: , period.period_year
4611: , period.quarter_num
4612: FROM cn_period_statuses_all period
4613: WHERE period.period_id = l_period_id AND org_id = g_org_id;
4614:
4615: l_prd l_period_info_csr%ROWTYPE;
4616: l_end_prd l_period_info_csr%ROWTYPE;

Line 4645: FROM cn_period_statuses_all

4641: CLOSE l_sub_batch_csr;
4642:
4643: SELECT period_id
4644: INTO l_start_period_id
4645: FROM cn_period_statuses_all
4646: WHERE l_start_date BETWEEN start_date AND end_date
4647: AND org_id = l_org_id
4648: AND (period_set_id, period_type_id) = (SELECT period_set_id
4649: , period_type_id

Line 4655: FROM cn_period_statuses_all

4651: WHERE org_id = l_org_id);
4652:
4653: SELECT period_id
4654: INTO l_end_period_id
4655: FROM cn_period_statuses_all
4656: WHERE l_end_date BETWEEN start_date AND end_date
4657: AND org_id = l_org_id
4658: AND (period_set_id, period_type_id) = (SELECT period_set_id
4659: , period_type_id