Custom SQL Criteria in Person Security Profile

Summary

Is it possible to use given construct to only show employees based on logged in Employee

Content

I know I can use this kind of construct to get logged in user's details. Does this work in Custom SQL criteria If I have a complex SQL and want to pass logged in person_ID using this construct. I know it works fine in BIP.

 

select * from per_all_people_f where person_id in (SELECT HRC_SESSION_UTIL.GET_USER_PERSONID FROM DUAL)

Version

19C