UDT under Person security profile custom criteria

Hi Team,

Our previous version custom criteria used hard coded value for 'ATTRIBUTE20'. But, we need to have the dynamic values. So, I am trying to use UDT contains person id and value of ATTRIBUTE20. I am not getting any syntax error but not giving correct values. Any idea? Below is the query.

EXISTS (SELECT 1

FROM PER_ALL_ASSIGNMENTS_M ASG

WHERE ASG.ASSIGNMENT_TYPE IN('E')

AND ASG.EFFECTIVE_LATEST_CHANGE='Y'

AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE

AND ASG.ASSIGNMENT_ID= &TABLE_ALIAS.ASSIGNMENT_ID

AND TRANSLATE(ATTRIBUTE20, ':',' ') IN (SELECT VAL.USER_COLUMN_NAME