DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_QUOTA_RULES

Line 132: cn_quota_rules qr,

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
136: l_start_date <= nvl(dh.end_date, l_start_date)