UDA Dependent attribute for minority type

Hello,

Need clarification to draft my query to display the minority type on UDA.  I want minority type column should display value if i select classification as Minority Owned (which is similar functionality in business classification page)

I tried as per note 729693.1, however i confused to get the value how can i get minority type values only if i choose classification as "Minority Owned"

select tra.minority_type from fnd_lookup_values flv, pos_tier_report_agv tra

where tra.diversity_classi_disp= :$ATTRIBUTEGROUP$.diversity_classi

and DIVERSITY_CLASSI_DISP= 'MINORITY_OWNED'

and flv.lookup_type= 'MINORITY GROUP' and flv.enabled_flag= 'Y' and flv.start_date_active< SYSDATE and (flv.end_date_active > SYSDATE or flv.end_date_active is null)