APPS.CN_PROC_BATCHES_PKG dependencies on CN_COMP_PLANS

Line 884: FROM cn_comp_plans_all

880: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
881:
882: CURSOR plan_status(p_comp_plan_id NUMBER) IS
883: SELECT status_code
884: FROM cn_comp_plans_all
885: WHERE comp_plan_id = p_comp_plan_id;
886: BEGIN
887: OPEN l_sub_batch_csr;
888: FETCH l_sub_batch_csr INTO l_start_date_orig, l_end_date_orig, l_salesrep_option, l_org_id;

Line 925: , cn_comp_plans_all PLAN

921: FROM (SELECT PLAN.comp_plan_id
922: , COUNT(DISTINCT spa.salesrep_id) num_of_affected_reps
923: FROM cn_srp_plan_assigns_all spa
924: , cn_srp_role_dtls_all srd
925: , cn_comp_plans_all PLAN
926: WHERE PLAN.org_id = l_org_id
927: AND PLAN.status_code = 'INCOMPLETE'
928: AND spa.comp_plan_id = PLAN.comp_plan_id
929: AND GREATEST(spa.start_date, l_start_date_adj) <=

Line 964: , cn_comp_plans_all PLAN

960: , COUNT(DISTINCT spa.salesrep_id) num_of_affected_reps
961: FROM cn_calc_submission_entries cse
962: , cn_srp_plan_assigns_all spa
963: , cn_srp_role_dtls_all srd
964: , cn_comp_plans_all PLAN
965: WHERE cse.calc_sub_batch_id = p_calc_sub_batch_id
966: AND spa.salesrep_id = cse.salesrep_id
967: AND PLAN.org_id = l_org_id
968: AND PLAN.status_code = 'INCOMPLETE'

Line 1009: , cn_comp_plans_all PLAN

1005: FROM (SELECT PLAN.comp_plan_id
1006: , COUNT(DISTINCT spa.salesrep_id) num_of_affected_reps
1007: FROM cn_srp_plan_assigns_all spa
1008: , cn_srp_role_dtls_all srd
1009: , cn_comp_plans_all PLAN
1010: WHERE PLAN.org_id = l_org_id
1011: AND PLAN.status_code = 'INCOMPLETE'
1012: AND spa.comp_plan_id = PLAN.comp_plan_id
1013: AND GREATEST(spa.start_date, l_start_date_orig) <=

Line 1046: , cn_comp_plans_all PLAN

1042: FROM (SELECT PLAN.comp_plan_id
1043: , COUNT(DISTINCT spa.salesrep_id) num_of_affected_reps
1044: FROM cn_srp_plan_assigns_all spa
1045: , cn_srp_role_dtls_all srd
1046: , cn_comp_plans_all PLAN
1047: WHERE PLAN.org_id = l_org_id
1048: AND PLAN.status_code = 'INCOMPLETE'
1049: AND spa.comp_plan_id = PLAN.comp_plan_id
1050: AND GREATEST(spa.start_date, l_start_date_orig) <=

Line 1183: FROM cn_srp_plan_assigns_all spa, cn_comp_plans_all PLAN

1179: AND intel.period_id BETWEEN l_calc_from_period_id AND l_calc_to_period_id
1180: AND (
1181: EXISTS(
1182: SELECT 1
1183: FROM cn_srp_plan_assigns_all spa, cn_comp_plans_all PLAN
1184: WHERE spa.salesrep_id = intel.salesrep_id
1185: AND spa.org_id = intel.org_id
1186: AND (
1187: (

Line 1298: FROM cn_srp_plan_assigns_all spa, cn_comp_plans_all PLAN

1294: OR (
1295: EXISTS -- salesrep has an active complete plan within the date range
1296: (
1297: SELECT 1
1298: FROM cn_srp_plan_assigns_all spa, cn_comp_plans_all PLAN
1299: WHERE spa.salesrep_id = cse.salesrep_id
1300: AND spa.org_id = cse.org_id
1301: AND (
1302: (

Line 4346: FROM cn_srp_plan_assigns_all spa, cn_comp_plans_all PLAN

4342: SELECT 1
4343: FROM DUAL
4344: WHERE EXISTS(
4345: SELECT 1
4346: FROM cn_srp_plan_assigns_all spa, cn_comp_plans_all PLAN
4347: WHERE spa.salesrep_id = p_salesrep_id
4348: AND spa.org_id = p_org_id
4349: AND (
4350: (

Line 4431: FROM cn_comp_plans

4427: AND spa.start_date <= bat.end_date
4428: AND (spa.end_date IS NULL OR spa.end_date >= bat.start_date)
4429: --code added for forwardport bug 6600074
4430: AND EXISTS(SELECT 1
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

Line 4475: cn_comp_plans PLAN

4471: FROM cn_srp_plan_assigns_all spa
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