query to fetch work relationship data for terminated employee in oracle fusion hcm

Summary:

I want to fetch Notice Served information for an employee which is a DFF and DESCRIPTIVE_FLEXFIELD_CODE = 'PER_PPS_DF'

Content (please ensure you mask any confidential information):

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

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