Query to get Concurrent Program details for given Value Set Name in Oracle APPS

select fcpl.user_concurrent_program_name
      , fcp.concurrent_program_name
      , fav.application_short_name
      , fav.application_name
      , ffvs.flex_value_set_name
      , flv.meaning default_type
 from   fnd_concurrent_programs fcp
      , fnd_concurrent_programs_tl fcpl
      , fnd_descr_flex_col_usage_vl fdfcuv
      , fnd_flex_value_sets ffvs
      , fnd_lookup_values flv
      , fnd_application_vl fav
 where  fcp.concurrent_program_id = fcpl.concurrent_program_id
 and    fcpl.language = 'US'
 and    fav.application_id=fcp.application_id
 and    fdfcuv.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
 and    ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
 and    flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
 and    flv.lookup_code(+) = fdfcuv.default_type
 and    flv.language(+) = userenv ('LANG')
 AND ffvs.flex_value_set_name = :value_set_name