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_ROLE_DTLS_ALL

Line 924: , cn_srp_role_dtls_all srd

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'
928: AND spa.comp_plan_id = PLAN.comp_plan_id

Line 963: , cn_srp_role_dtls_all srd

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
967: AND PLAN.org_id = l_org_id

Line 1008: , cn_srp_role_dtls_all srd

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'
1012: AND spa.comp_plan_id = PLAN.comp_plan_id

Line 1045: , cn_srp_role_dtls_all srd

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'
1049: AND spa.comp_plan_id = PLAN.comp_plan_id