Position Extract - Fast formula to get parent position Name

Summary:

Summary:
Hi Experts,
I need your assistance.

I'm currently working on the position object task.

I'm unable to search the parent position DB item in the entity (PER_EXT_SEC_HISTORY_POSITION_UE), I need the parent position name.

So, I created a valueset and a fast formula. The issue is that I can see the values in my valueset query, but the fast formula result is null.

Value Sets:

Select hapft.name , pphf.position_id

From hr_all_positions_f hapf, hr_all_positions_f_tl hapft,per_position_hierarchy_f pphf

Where hapf.position_id = pphf.parent_position_idAND pphf.position_id= 300000007421865--:{PARAMETER.POSITION_ID}AND hapf.position_id = hapft.position_idAND trunc(SYSDATE) BETWEEN hapft.effective_start_date AND hapft.effective_end_dateAND trunc(SYSDATE) BETWEEN pphf.effective_start_date AND pphf.effective_end_dateAND trunc(SYSDATE) BETWEEN hapf.effective_start_date AND hapf.effective_end_dateAND hapft.LANGUAGE = 'US'