APPS.CN_QUOTA_RULES_PKG dependencies on CN_DIM_EXPLOSION

Line 737: FROM cn_dim_explosion de1,

733: l_dim_hierarchy_id NUMBER
734: )
735: IS
736: SELECT rv.NAME
737: FROM cn_dim_explosion de1,
738: cn_dim_explosion de2,
739: cn_quota_rules qr,
740: cn_revenue_classes rv
741: WHERE de1.dim_hierarchy_id = l_dim_hierarchy_id

Line 738: cn_dim_explosion de2,

734: )
735: IS
736: SELECT rv.NAME
737: FROM cn_dim_explosion de1,
738: cn_dim_explosion de2,
739: cn_quota_rules qr,
740: cn_revenue_classes rv
741: WHERE de1.dim_hierarchy_id = l_dim_hierarchy_id
742: AND de2.dim_hierarchy_id = l_dim_hierarchy_id

Line 762: FROM cn_dim_explosion a,

758: FOR c1_row IN c1_cur
759: LOOP
760: SELECT COUNT (*)
761: INTO l_count
762: FROM cn_dim_explosion a,
763: cn_quota_rules b
764: WHERE a.dim_hierarchy_id = c1_row.dim_hierarchy_id
765: AND a.hierarchy_level <> 0 /*Do not self reference */
766: AND b.quota_id = x_quota_id

Line 785: cn_dim_explosion d

781: l_rev_class_name_child
782: FROM cn_revenue_classes a,
783: cn_revenue_classes b,
784: cn_quota_rules c,
785: cn_dim_explosion d
786: WHERE d.hierarchy_level <> 0
787: AND d.dim_hierarchy_id = c1_row.dim_hierarchy_id
788: AND c.revenue_class_id <> NVL (x_revenue_class_id_old, -999)
789: AND b.revenue_class_id = c.revenue_class_id