DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_DIM_HIERARCHIES

Line 133: cn_dim_hierarchies dh

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