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

 select fa.application_name, fe.executable_name,fe.execution_file_name package_name,

fcp.concurrent_program_id,fcpt.user_concurrent_program_name,fcp.concurrent_program_name

from fnd_executables fe,fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_application_tl fa

where fe.executable_id = fcp.executable_id

and  fcp.concurrent_program_id = fcpt.concurrent_program_id

and fcp.concurrent_program_name in ( Concurrent program short name)

and fcp.application_id = fa.application_id