Query to find Concurrent Program with Parameters in Oracle Apps

  SELECT fcpl.user_concurrent_program_name,
         fcp.concurrent_program_name,
         fav.application_short_name,
         fav.application_name,
         fav.application_id,
         fdfcuv.end_user_column_name,
         fdfcuv.form_left_prompt prompt,
         fdfcuv.enabled_flag,
         fdfcuv.required_flag,
         fdfcuv.display_flag,
         fdfcuv.flex_value_set_id,
         ffvs.flex_value_set_name,
         flv.meaning default_type,
         fdfcuv.DEFAULT_VALUE
    FROM apps.fnd_concurrent_programs fcp,
         apps.fnd_concurrent_programs_tl fcpl,
         apps.fnd_descr_flex_col_usage_vl fdfcuv,
         apps.fnd_flex_value_sets ffvs,
         apps.fnd_lookup_values flv,
         apps.fnd_application_vl fav
   WHERE     fcp.concurrent_program_id = fcpl.concurrent_program_id
         AND fcpl.user_concurrent_program_name = :conc_prg_name
         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')
ORDER BY fdfcuv.end_user_column_name;