APPS.WF_QUEUE dependencies on ALL_QUEUE_TABLES

Line 2969: from all_queue_tables

2965:
2966: /*
2967: cursor c_qt is
2968: select owner
2969: from all_queue_tables
2970: where queue_table = l_qt;
2971: */
2972:
2973: -- Changed non-cursor single row query to cursor based for improved perf.

Line 3143: FROM all_queue_tables

3139: l_excp_qname := 'AQ$_' || l_qname || '_E';
3140:
3141: SELECT TRIM(object_type)
3142: INTO l_object_type
3143: FROM all_queue_tables
3144: WHERE queue_table in
3145: (
3146: SELECT queue_table
3147: FROM all_queues

Line 3303: FROM all_queue_tables

3299: l_qname := substr(l_queue_name, l_pos+1);
3300:
3301: SELECT TRIM(object_type)
3302: INTO l_data_type
3303: FROM all_queue_tables
3304: WHERE queue_table in
3305: (
3306: SELECT queue_table
3307: FROM all_queues

Line 3491: FROM all_queue_tables

3487: l_qname := substr(l_queue_name, l_pos+1);
3488:
3489: SELECT TRIM(object_type)
3490: INTO l_data_type
3491: FROM all_queue_tables
3492: WHERE queue_table in
3493: (
3494: SELECT queue_table
3495: FROM all_queues