Get Status of Concurrent Program Schedule

SELECT ftl.user_concurrent_program_name,
(SELECT user_name
FROM fnd_user
WHERE user_id = fcr.requested_by) submitted_by,
(SELECT meaning
FROM fnd_lookup_values
WHERE lookup_type = 'CP_PHASE_CODE'
AND lookup_code = fcr.phase_code
AND view_application_id = 0) phase,
(SELECT LTRIM (meaning)
FROM fnd_lookup_values
WHERE lookup_type = 'CP_STATUS_CODE'
AND lookup_code = fcr.status_code
AND view_application_id = 0) status,
fcr.*
FROM apps.fnd_concurrent_requests fcr,
apps.fnd_concurrent_programs_tl ftl
WHERE fcr.concurrent_program_id = ftl.concurrent_program_id
AND ftl.user_concurrent_program_name LIKE 'XX_SSHR_CREATE_NEW_USERS'
ORDER BY request_date DESC;