Query to get HDL file details using UCM ID

Below is the query to get the HDL file information if the UCM ID is known : 

SELECT * FROM hrc_dl_file_lines 

WHERE data_set_bus_obj_id IN 

(SELECT data_set_bus_obj_id FROM hrc_dl_data_set_bus_objs WHERE data_set_id IN 

( SELECT data_set_id FROM hrc_dl_data_sets WHERE ucm_content_id = 'UCMXXXXXX'))