APPS.WF_EVENT dependencies on ALL_QUEUES

Line 3223: from all_queues aq

3219: -- retrieve recipients (MULTIPLE or SINGLE) for AQ
3220: -- 3659756 When get agent details, check if the enqueue and dequeue are enabled.
3221: select aq.queue_type, aq.QUEUE_TABLE, trim(dequeue_enabled)
3222: into WF_EVENT.g_queueType, l_queue_table, WF_EVENT.pv_last_dequeue_enabled
3223: from all_queues aq
3224: where aq.owner = l_owner
3225: and aq.name = l_name;
3226:
3227: select aqt.recipients, aqt.message_grouping

Line 3280: FROM all_queues

3276: --Bug 3659756, no longer start fixed name queues.
3277: /**
3278: CURSOR q_disabled (schema varchar2) is
3279: SELECT name
3280: FROM all_queues
3281: WHERE name in ('WF_DEFERRED', 'WF_ERROR', 'WF_JAVA_DEFERRED','WF_JAVA_ERROR')
3282: AND owner =schema
3283: AND ((trim(enqueue_enabled) = 'NO') OR (trim(dequeue_enabled) = 'NO'));
3284: */