APPS.CN_PROC_BATCHES_PKG dependencies on CN_QUOTAS

Line 4360: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe

4356: AND PLAN.status_code = 'COMPLETE')
4357: OR EXISTS -- comp_plan is active between period start and end date AND a plan element has the salesreps_enddated_flag set to "Y"
4358: (
4359: SELECT 1
4360: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe
4361: WHERE spa.salesrep_id = p_salesrep_id
4362: AND spa.org_id = p_org_id
4363: AND spa.end_date >= p_start_date
4364: AND spa.end_date < p_end_date

Line 4434: FROM cn_quota_assigns a, cn_quotas b

4430: FROM cn_comp_plans
4431: WHERE comp_plan_id = spa.comp_plan_id AND status_code = 'COMPLETE')
4432: AND EXISTS(
4433: SELECT 1
4434: FROM cn_quota_assigns a, cn_quotas b
4435: WHERE a.comp_plan_id = spa.comp_plan_id
4436: AND a.quota_id = b.quota_id
4437: AND b.incentive_type_code = 'BONUS'
4438: AND GREATEST(bat.start_date, b.start_date) <=

Line 4476: , cn_quotas b

4472: ,
4473: --code added for forwardport bug 6600074
4474: cn_comp_plans PLAN
4475: , cn_quota_assigns a
4476: , cn_quotas b
4477: --end of code added for forwardport bug 6600074
4478: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4479: AND spa.salesrep_id = cse.salesrep_id
4480: AND spa.org_id = bat.org_id

Line 4532: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe

4528: ))
4529: OR EXISTS -- comp_plan is active between period start and end date AND a plan element has the salesreps_enddated_flag set to "Y"
4530: (
4531: SELECT 1
4532: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe
4533: WHERE spa.salesrep_id = p_salesrep_id
4534: AND spa.org_id = bat.org_id
4535: AND spa.end_date >= period.start_date
4536: AND spa.end_date < period.end_date