APPS.CN_COMP_PLAN_PUB dependencies on CN_DIM_HIERARCHIES

Line 51: cn_dim_hierarchies dh

47: FROM cn_dim_explosion de,
48: cn_quota_rules qr,
49: cn_quota_assigns qa,
50: cn_quotas_v q,
51: cn_dim_hierarchies dh
52: WHERE dh.header_dim_hierarchy_id = l_rev_class_hierarchy_id
53: AND ( ( q.end_date IS NULL
54: AND NVL (TRUNC (dh.end_date), TRUNC (q.start_date)) >=
55: TRUNC (q.start_date)