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 3661: FROM cn_process_batches_all batch, cn_period_statuses_all per

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

Line 4262: FROM cn_period_statuses_all

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

Line 4301: FROM cn_period_statuses_all ps1, cn_period_statuses_all ps2

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

Line 4508: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

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

Line 4580: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

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

Line 4594: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

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

Line 4613: FROM cn_period_statuses_all period

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

Line 4646: FROM cn_period_statuses_all

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

Line 4656: FROM cn_period_statuses_all

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