APPS.FND_CONC_REQUEST_PKG dependencies on FND_CONCURRENT_WORKER_REQUESTS

Line 163: from fnd_concurrent_worker_requests

159: into upcode,
160: uscode
161: from sys.dual
162: where not exists (select null
163: from fnd_concurrent_worker_requests
164: where request_id = rid
165: and running_processes > 0
166: and (not (queue_application_id = 0
167: and concurrent_queue_id in (1,4))

Line 320: from fnd_concurrent_worker_requests b

316:
317: begin
318: select count (*) + 1
319: into reqpos
320: from fnd_concurrent_worker_requests b
321: where (b.priority < pri
322: or (b.priority = pri
323: and b.requested_start_date < stdate)
324: or (b.priority = pri

Line 351: from fnd_concurrent_worker_requests

347:
348: begin
349: select count (*)
350: into runreqs
351: from fnd_concurrent_worker_requests
352: where concurrent_queue_name = qname
353: and queue_application_id = qappid
354: and phase_code = 'R';
355:

Line 374: from fnd_concurrent_worker_requests

370:
371: begin
372: select count (*)
373: into pendreqs
374: from fnd_concurrent_worker_requests
375: where concurrent_queue_name = qname
376: and queue_application_id = qappid
377: and phase_code = 'P'
378: and hold_flag <> 'Y'