Concurrent program executable file name

Select a.concurrent_program_id, c.user_concurrent_program_name, a.concurrent_program_name, b.executable_name, b.execution_file_name, b.execution_file_path,
DECODE(b.EXECUTION_METHOD_CODE,'Q','SQLPLUS','P','Oracle Reports','I','PL/SQL Stored Procedure','L','SQLLOADER','H','HOST','A','SPAWNED','J','JAVA','R','SQLREPORT','X','Flexrpt','S','IMMEDIATE', 'K', 'Java Concurrent Program', b.execution_method_code)
EXECUTION_METHOD_CODE
from fnd_concurrent_programs a,
     fnd_executables b,
     fnd_concurrent_programs_tl c
where a.executable_id = b.executable_id
and a.concurrent_program_id = c.concurrent_program_id
and c.user_concurrent_program_name like <concurr_prog_name>