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

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

Line 4449: FROM cn_srp_plan_assigns_all

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

Line 4470: FROM cn_srp_plan_assigns_all spa

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

Line 4519: FROM cn_srp_plan_assigns_all spa

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

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