APPS.CN_RULESET_PUB dependencies on CN_LOOKUPS

Line 218: FROM cn_lookups

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'
220: AND meaning = l_ruleset_rec.module_type)
221: AND start_date = l_ruleset_rec.start_date
222: AND end_date = l_ruleset_rec.end_date;

Line 245: FROM cn_lookups

241: l_ruleset_rec_pvt.org_id := p_ruleset_rec.org_id;
242:
243: SELECT lookup_code
244: INTO l_ruleset_rec_pvt.module_type
245: FROM cn_lookups
246: WHERE lookup_type = 'MODULE_TYPE'
247: AND meaning = l_ruleset_rec.module_type;
248:
249: cn_ruleset_pvt.create_ruleset

Line 715: FROM cn_lookups

711: l_ruleset_rec_pvt.end_date := p_ruleset_rec.end_date;
712: l_ruleset_rec_pvt.org_id := p_ruleset_rec.org_id;
713: SELECT lookup_code
714: INTO l_ruleset_rec_pvt.module_type
715: FROM cn_lookups
716: WHERE lookup_type = 'MODULE_TYPE'
717: AND meaning = p_ruleset_rec.module_type;
718:
719: l_old_ruleset_rec_pvt.ruleset_name := p_old_ruleset_rec.ruleset_name;

Line 726: FROM cn_lookups

722: l_old_ruleset_rec_pvt.org_id := p_old_ruleset_rec.org_id;
723:
724: SELECT lookup_code
725: INTO l_old_ruleset_rec_pvt.module_type
726: FROM cn_lookups
727: WHERE lookup_type = 'MODULE_TYPE'
728: AND meaning = p_old_ruleset_rec.module_type;
729:
730: cn_ruleset_pvt.update_ruleset