eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PROC_BATCHES_PKG dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 923: FROM cn_srp_plan_assigns_all spa

919: , l_created_by
920: , l_creation_date
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'

Line 962: , cn_srp_plan_assigns_all spa

958: , l_creation_date
959: FROM (SELECT PLAN.comp_plan_id
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

Line 1007: FROM cn_srp_plan_assigns_all spa

1003: , l_created_by
1004: , l_creation_date
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'

Line 1044: FROM cn_srp_plan_assigns_all spa

1040: , l_created_by
1041: , l_creation_date
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'

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

4420: -- cursors to select salesrep with active comp plan within the calc_submission
4421: -- start_date and end_date
4422: CURSOR l_all_reps_csr IS
4423: SELECT DISTINCT spa.salesrep_id
4424: FROM cn_srp_plan_assigns_all spa, cn_calc_submission_batches_all bat
4425: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4426: AND spa.org_id = bat.org_id
4427: AND spa.start_date <= bat.end_date
4428: AND (spa.end_date IS NULL OR spa.end_date >= bat.start_date)

Line 4450: FROM cn_srp_plan_assigns_all

4446: AND org_id = l_org_id
4447: AND processing_status_code <> 'CLEAN'
4448: AND NOT EXISTS(
4449: SELECT 1
4450: FROM cn_srp_plan_assigns_all
4451: WHERE salesrep_id = sip.salesrep_id
4452: AND org_id = sip.org_id
4453: AND start_date <= sip.end_date
4454: AND NVL(end_date, sip.start_date) >= sip.start_date)

Line 4471: FROM cn_srp_plan_assigns_all spa

4467: WHERE cse.calc_sub_batch_id = p_calc_sub_batch_id
4468: AND (
4469: EXISTS(
4470: SELECT 1
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

Line 4520: FROM cn_srp_plan_assigns_all spa

4516: AND (
4517: EXISTS -- on period.end_date there is an active comp_plan
4518: (
4519: SELECT 1
4520: FROM cn_srp_plan_assigns_all spa
4521: WHERE spa.salesrep_id = p_salesrep_id
4522: AND spa.org_id = bat.org_id
4523: AND (
4524: (

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