Query to get request set concurrent programs

select user_concurrent_program_name

   from fnd_concurrent_programs_tl

  where concurrent_program_id in

           (select concurrent_program_id

              from fnd_request_set_programs

             where request_set_id =

                      (select request_set_id

                         from fnd_request_sets_tl

                        where upper(user_request_set_name) = upper('&request_set_name')));