APPS.CN_DIM_HIERARCHIES_PVT dependencies on CN_QUOTAS

Line 1159: cn_dim_hierarchies h, cn_quotas q, cn_revenue_classes r

1155:
1156: CURSOR dup_rev_classes is
1157: select h.start_date, h.end_date, r.name
1158: from cn_quota_rules r1, cn_quota_rules r2, cn_dim_explosion d,
1159: cn_dim_hierarchies h, cn_quotas q, cn_revenue_classes r
1160: where r1.revenue_class_id = p_external_id
1161: and r2.revenue_class_id = d.ancestor_external_id
1162: AND r.revenue_class_id = d.ancestor_external_id
1163: and d.value_id = p_parent_value_id