DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_QUOTA_RULES

Line 133: cn_quota_rules qr,

129: l_end_date date, l_quota_id1 number, l_quota_id2 number) IS
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)