APPS.WF_EVENT dependencies on ALL_QUEUES

Line 3161: from all_queues aq

3157: -- retrieve recipients (MULTIPLE or SINGLE) for AQ
3158: -- 3659756 When get agent details, check if the enqueue and dequeue are enabled.
3159: select aq.queue_type, aq.QUEUE_TABLE, trim(dequeue_enabled)
3160: into WF_EVENT.g_queueType, l_queue_table, WF_EVENT.pv_last_dequeue_enabled
3161: from all_queues aq
3162: where aq.owner = l_owner
3163: and aq.name = l_name;
3164:
3165: select aqt.recipients, aqt.message_grouping

Line 3218: FROM all_queues

3214: --Bug 3659756, no longer start fixed name queues.
3215: /**
3216: CURSOR q_disabled (schema varchar2) is
3217: SELECT name
3218: FROM all_queues
3219: WHERE name in ('WF_DEFERRED', 'WF_ERROR', 'WF_JAVA_DEFERRED','WF_JAVA_ERROR')
3220: AND owner =schema
3221: AND ((trim(enqueue_enabled) = 'NO') OR (trim(dequeue_enabled) = 'NO'));
3222: */