Query to get details of concurrent program parameters

1SELECT fcpl.user_concurrent_program_name,
2       fcp.concurrent_program_name,
3       par.end_user_column_name,
4       par.form_left_prompt prompt,
5       par.enabled_flag,
6       par.required_flag,
7       par.display_flag,
8       ffv.flex_value_set_name
9  FROM fnd_concurrent_programs     fcp,
10       fnd_concurrent_programs_tl  fcpl,
11       fnd_descr_flex_col_usage_vl par,
12       fnd_flex_value_sets         ffv
13 WHERE     fcp.concurrent_program_id = fcpl.concurrent_program_id
14       AND fcpl.user_concurrent_program_name = 'Your Concurrent Program Name' 
15       AND fcpl.LANGUAGE = 'US'
16       AND par.descriptive_flexfield_name =
17              '$SRS$.' || fcp.concurrent_program_name
18       AND ffv.flex_value_set_id = par.flex_value_set_id