Row level security by considering multiple columns from 2 tables

Dear Experts,

Need help to implement the row level security by considering multiple columns from 2 tables.

I have two tables [ cost code & user info] from which i have to consider the columns to implement the RLS.

From Cost table user assigned to Level 1 cost code should have access until cost code level 4 and User assigned under cost code level 4 should have only access to level 4. User assinged * in the user info table should have access to all the data. current relationship between the tables are Many to One and single direction cardinality. Using Path function i am getting an error [[ The value 1123456 is missing from cost table. Please add the missing data and try again]]