How to get candidate attachment documents (photo) to RTF template

Summary:

I want to get the photo in candidate attachment and put in RTF Word Template. Currently having issues to get the content from attachment.

How can I get this content and put it in RTF Template?

Content:

I use the fnd_documents_tl table, which contains the DM_DOCUMENT_ID and file_name columns. Despite searching in the Universal Content Management (UCM) system, I have been unable to locate the desired content.

Version: 24B

Code Snippet:

select fad.document_id, dtl.file_name, fad.pk1_value

FROM fnd_attached_documents fad,
fnd_documents d,
fnd_documents_tl dtl

where fad.document_id= d.document_id