DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_DIM_HIERARCHIES

Line 134: cn_dim_hierarchies dh

130: SELECT count(de.value_external_id),
131: count(distinct de.value_external_id)
132: FROM cn_dim_explosion de,
133: cn_quota_rules qr,
134: cn_dim_hierarchies dh
135: WHERE
136: -- dh.header_dim_hierarchy_id = l_rev_class_hierarchy_id AND
137: l_start_date <= nvl(dh.end_date, l_start_date)
138: AND dh.start_date <= nvl(l_end_date, dh.start_date)