To Find the executable name and package name of a concurrent program

SELECT a.user_concurrent_program_name, b.executable_name,
      b.execution_file_name package_name
 FROM fnd_concurrent_programs_vl a, fnd_executables_vl b
WHERE a.executable_id = b.executable_id
  AND user_concurrent_program_name like    'Concurrent program name'