APPS.CN_CALC_POPULATE_PVT dependencies on CN_DIM_HIERARCHIES_ALL

Line 283: cn_dim_hierarchies_all dh,

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,
284: jtf_rs_salesreps jrs,
285: jtf_rs_group_members mem,
286: jtf_rs_role_relations rr
287: where spa.salesrep_id = p_salesrep_id

Line 403: FROM cn_dim_hierarchies_all dh,

399: order by cl.processed_date, cl.credited_salesrep_id, ch.role_id;
400:
401: CURSOR l_dim_hierarchy_csr (l_processed_date DATE) IS
402: SELECT dim_hierarchy_id
403: FROM cn_dim_hierarchies_all dh,
404: cn_repositories_all r
405: WHERE r.org_id = g_org_id
406: AND r.rev_class_hierarchy_id = dh.header_dim_hierarchy_id
407: AND dh.org_id = g_org_id