APPS.WF_SETUP dependencies on WF_ALL_JOBS

Line 328: from WF_ALL_JOBS

324: -- lqr.name came from WF_AGENTS.NAME
325: -- BINDVAR_SCAN_IGNORE[6]
326: select 'YES'
327: into dTab(i).col02
328: from WF_ALL_JOBS
329: where upper(substr(WHAT, 1, 60))
330: like 'WF_EVENT.LISTEN('''||lqr.name||''')%'
331: and rownum < 2;
332: exception

Line 710: from WF_ALL_JOBS

706: -- nm came from WF_AGENTS.NAME
707: -- BINDVAR_SCAN_IGNORE[4]
708: cursor jobc(nm varchar2) is
709: select JOB, WHAT, upper(INTERVAL) interval
710: from WF_ALL_JOBS
711: where upper(WHAT) like 'WF_EVENT.LISTEN('''||nm||''');';
712:
713: username varchar2(320); -- Username to query
714: admin_role varchar2(320); -- Role for admin mode

Line 909: from WF_ALL_JOBS

905: l_interval varchar2(2000);
906:
907: cursor jobc(x_jobnum pls_integer) is
908: select NEXT_DATE, upper(INTERVAL) interval
909: from WF_ALL_JOBS
910: where job = x_jobnum;
911:
912: begin
913: -- Check session and current user

Line 1651: from WF_ALL_JOBS

1647: nDate date;
1648: begin
1649: begin
1650: select NEXT_DATE into nDate
1651: from WF_ALL_JOBS
1652: where job = jobnum;
1653: exception
1654: when NO_DATA_FOUND then
1655: return to_date(NULL);