Need to show the Rsignation Notification date in the assignment page as DFF

We have a requirment that we have to fetch the resignation notfication date in the Assigment page and try to do this by DFF read only option putting the Default value by below SQL.

SELECT

to_date(TO_char(ppos.NOTIFIED_TERMINATION_DATE,'DD/MM/YY')) NOTIFIED_TERMINATION_DATE

FROM

per_all_people_f papf,

PER_PERIODS_OF_SERVICE ppos

WHERE 1=1

AND ppos.person_id = papf.person_id

AND TRUNC(sysdate) BETWEEN TRUNC(papf.effective_start_date) AND TRUNC(papf.effective_end_date)

AND papf.person_id = :{PARAMETER.PERIOD_OF_SERVICE_ID}

But the SQL query is not showind data if any one have done this kind of requirement Your guidance will help us.