APPS.WF_SETUP dependencies on DBA_QUEUE_SCHEDULES

Line 466: from DBA_QUEUE_SCHEDULES QS

462: into dTab(i).col03
463: from sys.dual
464: where exists (
465: select NULL
466: from DBA_QUEUE_SCHEDULES QS
467: where QS.DESTINATION = nvl(ppgr.tosystem, 'AQ$_LOCAL')
468: and QS.SCHEMA||'.'||QS.QNAME = ppgr.oqueue);
469: exception
470: when NO_DATA_FOUND then

Line 1120: from DBA_QUEUE_SCHEDULES

1116: l_nexttime varchar2(2000);
1117:
1118: cursor ppgnc(x_qname varchar2, x_system varchar2) is
1119: select PROPAGATION_WINDOW, upper(NEXT_TIME) NEXT_TIME, LATENCY
1120: from DBA_QUEUE_SCHEDULES
1121: where DESTINATION = nvl(x_system, 'AQ$_LOCAL')
1122: and SCHEMA||'.'||QNAME = x_qname;
1123:
1124: l_pos pls_integer;