LAST TIME REPORT RUN RESPONSIBILITY

/* Formatted on 2019/11/28 11:43 (Formatter Plus v4.8.8) */
SELECT frt.responsibility_name                                                  --fcr.REQUEST_DATE
  FROM fnd_concurrent_requests fcr, fnd_concurrent_programs_tl fcpt,fnd_responsibility_tl frt
 WHERE fcr.concurrent_program_id = fcpt.concurrent_program_id
   AND fcr.program_application_id = fcpt.application_id
   AND frt.responsibility_id = FCR.responsibility_id
   AND fcr.actual_start_date > SYSDATE - :days_to_check
   AND fcpt.user_concurrent_program_name LIKE '%' || :program_name || '%'