1265: ,p_legislation_code in varchar2
1266: ) is
1267: select u.route_id
1268: from ff_database_items d 1269: , ff_user_entities u 1270: where d.user_name = p_dbi_name
1271: and d.user_entity_id = u.user_entity_id
1272: and (
1273: u.legislation_code is null and u.business_group_id is null or