APPS.XDP_FQUEUE_TOOLS dependencies on XDP_ADAPTER_JOB_QUEUE

Line 23: ELSIF queued_id = 'XDP_ADAPTER_JOB_QUEUE' THEN

19: ELSIF queued_id = 'XDP_FA_QUEUE' THEN
20: SELECT count(1)
21: INTO entries_number
22: FROM xdp_fa_qtab;
23: ELSIF queued_id = 'XDP_ADAPTER_JOB_QUEUE' THEN
24: SELECT count(1)
25: INTO entries_number
26: FROM xdp_adapter_job_queue;
27: ELSIF queued_id = 'XDP_WF_CHANNEL_Q' THEN

Line 26: FROM xdp_adapter_job_queue;

22: FROM xdp_fa_qtab;
23: ELSIF queued_id = 'XDP_ADAPTER_JOB_QUEUE' THEN
24: SELECT count(1)
25: INTO entries_number
26: FROM xdp_adapter_job_queue;
27: ELSIF queued_id = 'XDP_WF_CHANNEL_Q' THEN
28: SELECT count(1)
29: INTO entries_number
30: FROM xdp_wf_channel_qtab;

Line 73: ELSIF queued_id = 'XDP_ADAPTER_JOB_QUEUE' THEN

69: ELSIF queued_id = 'XDP_FA_QUEUE' THEN
70: SELECT max(ENQ_TIME)
71: INTO entry_date
72: FROM xdp_fa_qtab;
73: ELSIF queued_id = 'XDP_ADAPTER_JOB_QUEUE' THEN
74: SELECT max(QUEUED_ON)
75: INTO entry_date
76: FROM xdp_adapter_job_queue;
77: ELSIF queued_id = 'XDP_WF_CHANNEL_Q' THEN

Line 76: FROM xdp_adapter_job_queue;

72: FROM xdp_fa_qtab;
73: ELSIF queued_id = 'XDP_ADAPTER_JOB_QUEUE' THEN
74: SELECT max(QUEUED_ON)
75: INTO entry_date
76: FROM xdp_adapter_job_queue;
77: ELSIF queued_id = 'XDP_WF_CHANNEL_Q' THEN
78: SELECT max(enq_time)
79: INTO entry_date
80: FROM xdp_wf_channel_qtab;