APPS.CN_RULESET_PUB dependencies on CN_RULESETS

Line 212: --else use cn_rulesets_s.nextval

208: END IF;
209:
210: --Now check if the ruleset exists.
211: --If it does, then raise error
212: --else use cn_rulesets_s.nextval
213: SELECT count(1)
214: INTO l_count
215: FROM cn_rulesets
216: WHERE name = l_ruleset_rec.ruleset_name

Line 215: FROM cn_rulesets

211: --If it does, then raise error
212: --else use cn_rulesets_s.nextval
213: SELECT count(1)
214: INTO l_count
215: FROM cn_rulesets
216: WHERE name = l_ruleset_rec.ruleset_name
217: AND module_type = (SELECT lookup_code
218: FROM cn_lookups
219: WHERE lookup_type = 'MODULE_TYPE'

Line 680: --else use cn_rulesets_s.nextval

676:
677:
678: --Now check if the ruleset exists.
679: --If it does, then raise error
680: --else use cn_rulesets_s.nextval
681: SELECT count(1)
682: INTO l_count
683: FROM cn_rulesets
684: WHERE name = l_old_ruleset_rec.ruleset_name

Line 683: FROM cn_rulesets

679: --If it does, then raise error
680: --else use cn_rulesets_s.nextval
681: SELECT count(1)
682: INTO l_count
683: FROM cn_rulesets
684: WHERE name = l_old_ruleset_rec.ruleset_name
685: AND start_date = l_old_ruleset_rec.start_date
686: AND end_date = l_old_ruleset_rec.end_date;
687:

Line 702: FROM cn_rulesets

698: RAISE FND_API.G_EXC_ERROR;
699: ELSE
700: SELECT ruleset_id
701: INTO l_old_ruleset_rec_pvt.ruleset_id
702: FROM cn_rulesets
703: WHERE name = l_old_ruleset_rec.ruleset_name
704: AND start_date = l_old_ruleset_rec.start_date
705: AND end_date = l_old_ruleset_rec.end_date;
706: END IF;