APPS.CN_RULES_DISP_PUB dependencies on CN_RULES_HIERARCHY

Line 60: AND cnr.rule_id IN (SELECT rule_id FROM cn_rules_hierarchy);

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);
61:
62: CURSOR rules_cur(l_parent_rule_id NUMBER, l_ruleset_id NUMBER) IS
63: SELECT a.rule_level rule_level,cnr.name rule_name,
64: cnrc.name revenue_class, a.rule_id rule_id

Line 68: FROM cn_rules_hierarchy

64: cnrc.name revenue_class, a.rule_id rule_id
65: FROM
66: (
67: SELECT level rule_level, rule_id, parent_rule_id, sequence_number
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