DBA Data[Home] [Help]

APPS.WF_QUEUE dependencies on ALL_QUEUE_TABLES

Line 2989: from all_queue_tables

2985:
2986: /*
2987: cursor c_qt is
2988: select owner
2989: from all_queue_tables
2990: where queue_table = l_qt;
2991: */
2992:
2993: -- Changed non-cursor single row query to cursor based for improved perf.

Line 3163: FROM all_queue_tables

3159: l_excp_qname := 'AQ$_' || l_qname || '_E';
3160:
3161: SELECT TRIM(object_type)
3162: INTO l_object_type
3163: FROM all_queue_tables
3164: WHERE queue_table in
3165: (
3166: SELECT queue_table
3167: FROM all_queues

Line 3323: FROM all_queue_tables

3319: l_qname := substr(l_queue_name, l_pos+1);
3320:
3321: SELECT TRIM(object_type)
3322: INTO l_data_type
3323: FROM all_queue_tables
3324: WHERE queue_table in
3325: (
3326: SELECT queue_table
3327: FROM all_queues

Line 3511: FROM all_queue_tables

3507: l_qname := substr(l_queue_name, l_pos+1);
3508:
3509: SELECT TRIM(object_type)
3510: INTO l_data_type
3511: FROM all_queue_tables
3512: WHERE queue_table in
3513: (
3514: SELECT queue_table
3515: FROM all_queues