APPS.CN_DIM_HIERARCHIES_PVT dependencies on CN_QUOTA_RULES

Line 1158: from cn_quota_rules r1, cn_quota_rules r2, cn_dim_explosion d,

1154: l_head_hier_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
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