Flexfields with list of active employees - termination scenario

Summary:

Flexfields with list of active employees - termination scenario

Content (please ensure you mask any confidential information):

Hello experts, we have configured in the Department page a flexfield with a list of values showing only active employees. The value set has been configured as follow:

FROM CLAUSE: PER_PERSON_SECURED_LIST_V papf, per_person_names_f ppnf, per_all_assignments_m paam
VALUE COLUMN NAME: ppnf.display_name
ID COLUMN NAME: to_char(papf.person_id)
WHERE CLAUSE:
1=1
AND papf.person_id = paam.person_id
AND papf.person_id = ppnf.person_id
AND ppnf.name_type = 'GLOBAL'
AND TRUNC(SYSDATE) BETWEEN TRUNC(ppnf.effective_start_date)