Scheduled Concurrent Request Query in Oracle Applications

SELECT fl.meaning,
       fu.user_name,
       fu.description requestor,
       fu.end_date,
       NVL (fu.email_address, 'n/a') email_address,
       fcr.request_id,
       fcr.number_of_copies,
       fcr.printer,
       fcr.request_date,
       fcr.requested_start_date,
       fcp.user_concurrent_program_name,
       fcp.description,
       fcr.argument_text,
       frt.responsibility_name
  FROM apps.fnd_concurrent_requests fcr,
       apps.fnd_user fu,
       apps.fnd_lookups fl,
       apps.fnd_concurrent_programs_vl fcp,
       apps.fnd_responsibility_tl frt
 WHERE     fcr.requested_by = fu.user_id
       AND fl.lookup_type = 'CP_STATUS_CODE'
       AND fcr.status_code = fl.lookup_code
       AND fcr.program_application_id = fcp.application_id
       AND fcr.concurrent_program_id = fcp.concurrent_program_id
       AND fcr.responsibility_id = frt.responsibility_id
       AND NVL ( :Concurrent_program_name, fcp.user_concurrent_program_name) =
              fcp.user_concurrent_program_name
       AND fcr.phase_code = 'P'