Using url_id to find reference to file

So I need to find a way to use the url_id to see which records use that particular file. For instance:

select * from psurldefn where url like '%ourpathhere%';

Gives me a row with URL_ID = 'N_SOMEID' and a full path to it in the URL field (usually a PDF file hosted on an external HTTP repository). How can I use this information to find out how the file is actually being used? I basically need to know if it's in a program that creates emails with the file in the body, or if they're hyperlinked in online pages, etc. I was able to do it using text_id's in the Text Catalog. Is there something similar to that for URLs? (PS 9.1, PT 8.52)