Unable to pass Organization ID as parameter for Table value set created for Position DFF.

I am using the below in Valueset.

FROM Clause - hr_all_organization_units_f_vl haoufv
Value Column Name - SUBSTR(SUBSTR(haoufv.name,1,INSTR(haoufv.name,'_')-1),1,150)
ID Column Name - SUBSTR(SUBSTR(haoufv.name,1,INSTR(haoufv.name,'_')-1),1,150)
where - haoufv.organization_id IN (
SELECT potnv2.parent_organization_id
FROM per_org_tree_node_v potnv
per_org_tree_node_v potnv2
fnd_tree_version ftv
WHERE potnv.tree_version_id = ftv.tree_version_id
AND potnv.tree_code = ftv.tree_code
AND potnv2.organization_id = potnv.parent_organization_id
AND potnv.tree_structure_code = 'PER_ORG_TREE_STRUCTURE'