APPS.CN_PROC_BATCHES_PKG dependencies on CN_QUOTA_ASSIGNS

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

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

Line 4435: FROM cn_quota_assigns a, cn_quotas b

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

Line 4476: , cn_quota_assigns a

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

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

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