Oracle apps Value set - Sample Code

SELECT ffv.attribute1

  FROM fnd_flex_value_sets ffvs, fnd_flex_values_tl ffvt, fnd_flex_values ffv

 WHERE     ffvs.flex_value_set_name = 'XX_SAMPLE_VALUESET_VS'

       AND ffvs.flex_value_set_id = ffv.flex_value_set_id

       AND ffv.flex_value_id = ffvt.flex_value_id

       AND ffvt.description = lv_value

       AND ffvt.language = USERENV ('LANG')

       AND ffv.enabled_flag = 'Y'

       AND TRUNC (SYSDATE) >= NVL (ffv.start_date_active, SYSDATE - 1)

       AND TRUNC (SYSDATE) <= NVL (ffv.end_date_active, SYSDATE + 1);