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 4345: FROM cn_srp_plan_assigns_all spa, cn_comp_plans_all PLAN

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

Line 4430: FROM cn_comp_plans

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

Line 4474: cn_comp_plans PLAN

4470: FROM cn_srp_plan_assigns_all spa
4471: , cn_calc_submission_batches_all bat
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