APPS.CN_RULES_DISP_PUB dependencies on CN_REVENUE_CLASSES

Line 56: FROM cn_rules cnr, cn_revenue_classes cnrc

52:
53: CURSOR rules_cur1(l_parent_rule_id NUMBER, l_ruleset_id NUMBER) IS
54: SELECT 0 rule_level, cnr.name rule_name, cnrc.name revenue_class,
55: cnr.rule_id rule_id
56: FROM cn_rules cnr, cn_revenue_classes cnrc
57: WHERE cnr.rule_id = Nvl(l_parent_rule_id,-1002)
58: AND cnr.ruleset_id = Nvl(l_ruleset_id,-1002)
59: AND cnr.revenue_class_id = cnrc.revenue_class_id (+)
60: AND cnr.rule_id IN (SELECT rule_id FROM cn_rules_hierarchy);

Line 72: ) a , cn_rules cnr, cn_revenue_classes cnrc

68: FROM cn_rules_hierarchy
69: WHERE ruleset_id=Nvl(l_ruleset_id,-1002)
70: CONNECT BY PRIOR rule_id = parent_rule_id
71: START WITH parent_rule_id = Nvl(l_parent_rule_id, -1002)
72: ) a , cn_rules cnr, cn_revenue_classes cnrc
73: WHERE a.rule_id = cnr.rule_id
74: AND cnr.ruleset_id = Nvl(l_ruleset_id,-1002)
75: AND cnr.revenue_class_id = cnrc.revenue_class_id (+);
76: