DBA Data[Home] [Help]

APPS.CN_RULESET_PVT dependencies on CN_RULES_ALL_B

Line 162: FROM cn_rules_all_b

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:

Line 667: FROM cn_rules_all_b

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: