Either set up a select query like this:
select '#notifications.' || name || '#' as name,
where notification_intervals.interval_id = notification_types_intervals.interval_id
and type_id = :type_id
order by n_seconds
Note that some types of display procs do not automatically process these snippets - i've encountred this a few times, so if they don't it would need to be the same thing without the hash (#) sign and then run [_ notifications.name] as a seperate process in tcl.
Or, even better, if you don't have the problems mentioned above would be to upgrade notifications and store the values as MESSAGE KEY MISSING: 'notification.name' in the database table, that way they show up everywhere as translated messages. This is how thing such as dotlrn relationship types are stored in the db.