158: l_env_org_id NUMBER;
159:
160: CURSOR record_exists IS
161: SELECT count(1) cnt
162: FROM cn_rules_all_b
163: WHERE ruleset_id = p_ruleset_id
164: AND rule_id <> -1002
165: AND org_id = l_env_org_id;
166:
663: l_env_org_id NUMBER;
664:
665: CURSOR rules IS
666: SELECT count(1)
667: FROM cn_rules_all_b
668: WHERE ruleset_id = p_old_ruleset_rec.ruleset_id
669: and rule_id <> -1002 and
670: org_id = p_old_ruleset_rec.org_id;
671: