DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_DIM_EXPLOSION

Line 131: FROM cn_dim_explosion de,

127: cursor check_overlap_curs(l_rev_class_hierarchy_id number,l_start_date date,
128: l_end_date date, l_quota_id1 number, l_quota_id2 number) IS
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