APPS.CN_QUOTA_RULES_PKG dependencies on CN_REVENUE_CLASSES

Line 578: FROM cn_revenue_classes

574: IF x_revenue_class_id IS NOT NULL
575: THEN
576: SELECT NAME
577: INTO x_revenue_class_name
578: FROM cn_revenue_classes
579: WHERE revenue_class_id = x_revenue_class_id;
580: END IF;
581: EXCEPTION
582: WHEN NO_DATA_FOUND

Line 740: cn_revenue_classes rv

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
743: AND de1.value_external_id = de2.value_external_id
744: AND de1.ancestor_external_id = x_revenue_class_id

Line 782: FROM cn_revenue_classes a,

778: SELECT a.NAME,
779: b.NAME
780: INTO l_rev_class_name_parent,
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

Line 783: cn_revenue_classes b,

779: b.NAME
780: INTO l_rev_class_name_parent,
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

Line 820: FROM cn_revenue_classes a

816: -- where a.period_id = X_start_period_id
817: -- and b.period_id = X_end_period_id;
818: SELECT a.NAME
819: INTO l_rev_class_name_parent
820: FROM cn_revenue_classes a
821: WHERE a.revenue_class_id = x_revenue_class_id;
822:
823: fnd_message.set_name ('CN', 'REV_CLASS_COMMON_CHILD');
824: fnd_message.set_token ('PERIODS', l_periods);