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 2216: FROM cn_quotas_all

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

Line 2453: FROM cn_quotas_all

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

Line 3016: FROM cn_quotas_all cq, cn_srp_period_quotas_all spq

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

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

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