Query to find Oracle Concurrent Program Last Run Time:

SELECT DISTINCT user_concurrent_program_name,

                (SELECT MAX (actual_start_date)

                   FROM APPS.FND_CONCURRENT_REQUESTS x

                  WHERE x.concurrent_program_id = fcp.concurrent_program_id)

                   last_run_date,

                fu.user_name,

                frt.responsibility_name

  FROM apps.fnd_concurrent_programs_tl fcpt,

       apps.fnd_concurrent_programs fcp,

       apps.fnd_concurrent_requests fcr,

       apps.fnd_user fu,

       apps.fnd_responsibility_tl frt

 WHERE     1 = 1

       AND fcp.concurrent_Program_id = fcpt.concurrent_program_id

       AND fcp.concurrent_program_id = fcr.concurrent_program_id(+)

       AND fu.user_id = fcr.requested_by

       AND frt.responsibility_id = fcr.RESPONSIBILITY_ID

       AND user_concurrent_program_name = 'XXXX Program Name'