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_CALC_POPULATE_PVT dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 279: from cn_srp_plan_assigns_all spa,

275: least(nvl(dh.end_date, p_end_date),
276: nvl(spa.end_date, p_end_date),
277: nvl(q.end_date, p_end_date),
278: nvl(rr.end_date_active, p_end_date), p_end_date) end_date
279: from cn_srp_plan_assigns_all spa,
280: cn_srp_quota_assigns_all sqa,
281: cn_quotas_all q,
282: cn_quota_rules_all qr,
283: cn_dim_hierarchies_all dh,

Line 339: from cn_srp_plan_assigns_all spa,

335: greatest(spa.start_date, q.start_date, rr.start_date_active, p_start_date) start_date,
336: least(nvl(spa.end_date, p_end_date),
337: nvl(q.end_date, p_end_date),
338: nvl(rr.end_date_active, p_end_date), p_end_date) end_date
339: from cn_srp_plan_assigns_all spa,
340: cn_srp_quota_assigns_all sqa,
341: cn_quotas_all q,
342: cn_quota_rules_all qr,
343: jtf_rs_salesreps jrs,

Line 414: FROM cn_srp_plan_assigns_all spa

410: CURSOR l_spa_csr (l_processed_date DATE,
411: l_salesrep_id NUMBER,
412: l_role_id NUMBER ) IS
413: SELECT spa.srp_plan_assign_id
414: FROM cn_srp_plan_assigns_all spa
415: WHERE spa.role_id = l_role_id
416: AND spa.salesrep_id = l_salesrep_id
417: AND spa.org_id = g_org_id
418: and exists (select comp_plan_id from cn_comp_plans_all where status_code = 'COMPLETE' AND comp_plan_id = spa.comp_plan_id)