DBA Data[Home] [Help]

APPS.FND_CONC dependencies on FND_USER

Line 491: -- Check the user in FND_USER

487:
488: else
489: -- Here is a special case. If the user is invalid or end-dated,
490: -- this request will never be released by the CRM.
491: -- Check the user in FND_USER
492: select count(*)
493: into cnt
494: from fnd_user fu, fnd_concurrent_requests fcr
495: where fcr.request_id = P_REQUEST_ID

Line 494: from fnd_user fu, fnd_concurrent_requests fcr

490: -- this request will never be released by the CRM.
491: -- Check the user in FND_USER
492: select count(*)
493: into cnt
494: from fnd_user fu, fnd_concurrent_requests fcr
495: where fcr.request_id = P_REQUEST_ID
496: and fu.user_id = fcr.requested_by
497: and (fu.end_date is null or fu.end_date > sysdate);
498:

Line 801: fnd_user U1, fnd_user U2,

797: P_PROGRAM, P_QUEUE_CONTROL_FLAG,
798: P_QUEUE_METHOD_CODE, P_RUN_ALONE_FLAG,
799: P_SINGLE_THREAD_FLAG, P_REQLIMIT_FLAG, P_CD_ID, P_EDITION_NAME
800: from fnd_concurrent_requests R, fnd_concurrent_programs_vl CP,
801: fnd_user U1, fnd_user U2,
802: fnd_application_vl FA
803: where R.request_id = diagnose.request_id
804: and R.program_application_id = FA.application_id
805: and R.program_application_id = CP.application_id (+)