- 
select
 - 
ffv.flex_value,
 - 
ffv.flex_value_meaning,
 - 
ffv.description
 - 
from apps.FND_FLEX_VALUES_VL ffv
 - 
left join fnd_flex_value_sets ffvs on ffvs.flex_value_set_id=ffv.flex_value_set_id
 - 
where ffvs.flex_value_set_name='GC_PENSION_SCHEME'
 - 
and ffv.enabled_flag='Y'
 
See also
Search Terms
Validation Set Value
RJM Article Type
              Work Notes