APPS.CN_RULE_PUB dependencies on CN_RULES_V

Line 649: FROM cn_rules_v cnrv, cn_rules cnr1, cn_rules cnr2

645:
646:
647: CURSOR get_rules(p_ruleset_id cn_rulesets.ruleset_id%TYPE,p_org_id cn_rulesets.org_id%TYPE) IS
648: SELECT cnrv.rule_id, cnrv.parent_rule_id
649: FROM cn_rules_v cnrv, cn_rules cnr1, cn_rules cnr2
650: WHERE cnr1.name = l_old_rule_rec.rule_name
651: AND cnr2.name = l_old_rule_rec.parent_rule_name
652: AND cnr1.ruleset_id = p_ruleset_id
653: AND cnr2.ruleset_id = p_ruleset_id