Table Value set not returning data?

Summary:

I have a scenario where in i need to pull data stored in DFF and into another dff as read-only. The query below is generating data in Data model but not via value set

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT dor.DEI_ATTRIBUTE1

FROM per_all_people_f papf

  ,hr_documents_of_record dor

  ,hr_document_types_vl doc_type

WHERE Trunc(SYSDATE) BETWEEN Trunc(Nvl(papf.effective_start_date, SYSDATE)) AND Trunc(Nvl(papf.effective_end_date, SYSDATE))

  AND papf.person_id = dor.person_id