Available parameters to use in PER_ASG_DF?

Summary

Need to restrict values in PER_ASG_DF segment based on person_type

Content

Hi,

We would need to restrict the values in a PER_ASG_DF segment based on the person_type(_id).  We have created the lookup, created a value set based on the lookup  and used followinq query to limit the results in the value set:

 

Where clause:

LOOKUP_TYPE = 'Name of our lookup'

AND LANGUAGE IN USERENV('LANG')
AND TAG LIKE '%+'||:{PARAMETER.PERSON_TYPE_ID}||'%' OR TAG IS NULL

 

Whichever person type we use, we still get all values in the flexvield segment, so it doesn't seem to take into account the person type.