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_MARK_EVENTS_PKG dependencies on CN_QUOTAS_ALL

Line 598: FROM cn_quotas_all q

594: FROM cn_cal_per_int_types_all
595: WHERE cal_period_id = p_period_id
596: AND interval_type_id IN(
597: SELECT DISTINCT q.interval_type_id
598: FROM cn_quotas_all q
599: WHERE q.quota_id IN(
600: SELECT quota_id
601: FROM cn_srp_quota_assigns_all
602: WHERE srp_plan_assign_id IN(

Line 644: FROM cn_quotas_all pe

640: WHERE cpit1.cal_period_id = p_period_id
641: AND cpit1.org_id = p_org_id
642: AND cpit1.interval_type_id =
643: (SELECT interval_type_id
644: FROM cn_quotas_all pe
645: WHERE pe.quota_id = p_quota_id
646: AND (
647: pe.incremental_type = 'N'
648: OR (

Line 1868: FROM cn_quotas_all

1864:
1865: CURSOR l_quota_dates_csr IS
1866: SELECT start_date
1867: , end_date
1868: FROM cn_quotas_all
1869: WHERE quota_id = p_object_id;
1870:
1871: --clku
1872: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS

Line 2218: FROM cn_quotas_all

2214:
2215: CURSOR l_quota_dates_csr IS
2216: SELECT start_date
2217: , end_date
2218: FROM cn_quotas_all
2219: WHERE quota_id = p_object_id;
2220:
2221: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
2222: SELECT quota_id

Line 2455: FROM cn_quotas_all

2451:
2452: CURSOR l_quota_dates_csr IS
2453: SELECT start_date
2454: , end_date
2455: FROM cn_quotas_all
2456: WHERE quota_id = p_object_id;
2457:
2458: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
2459: SELECT quota_id

Line 3018: FROM cn_quotas_all cq, cn_srp_period_quotas_all spq

3014: -- modified by rjin 11/10/1999 add distinct
3015: SELECT DISTINCT spq.salesrep_id
3016: , spq.period_id
3017: , spq.quota_id
3018: FROM cn_quotas_all cq, cn_srp_period_quotas_all spq
3019: , cn_srp_intel_periods_all intel
3020: WHERE cq.calc_formula_id = p_object_id
3021: AND cq.org_id = p_org_id
3022: AND spq.quota_id = cq.quota_id

Line 3469: FROM cn_quotas_all q, cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel

3465: CURSOR affected_srp_period_quotas IS
3466: SELECT DISTINCT spq.salesrep_id
3467: , spq.period_id
3468: , spq.quota_id
3469: FROM cn_quotas_all q, cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel
3470: WHERE q.interval_type_id = p_interval_type_id
3471: AND q.org_id = p_org_id
3472: AND p_end_date >= q.start_date
3473: AND (q.end_date IS NULL OR p_start_date <= q.end_date)