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_CALC_SUBMISSION_ENTRIES

Line 961: FROM cn_calc_submission_entries cse

957: , l_created_by
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

Line 1264: FROM cn_calc_submission_entries_all cse

1260: DECLARE
1261: CURSOR l_reps_csr(l_start_date DATE, l_end_date DATE) IS
1262: SELECT cse.salesrep_id
1263: , NVL(cse.hierarchy_flag, 'N') hierarchy_flag
1264: FROM cn_calc_submission_entries_all cse
1265: WHERE cse.calc_sub_batch_id = p_calc_sub_batch_id
1266: AND (
1267: (
1268: EXISTS(

Line 4465: FROM cn_calc_submission_entries_all cse

4461:
4462: CURSOR l_user_reps_csr IS
4463: SELECT cse.salesrep_id
4464: , NVL(cse.hierarchy_flag, 'N') hierarchy_flag
4465: FROM cn_calc_submission_entries_all cse
4466: WHERE cse.calc_sub_batch_id = p_calc_sub_batch_id
4467: AND (
4468: EXISTS(
4469: SELECT 1