DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on USER_JOBS

Line 2103: user_jobs b

2099: b.what,
2100: b.last_Date,
2101: b.last_sec
2102: from fnd_svc_comp_requests a,
2103: user_jobs b
2104: WHERE a.component_id = p_comp_id
2105: AND a.job_id = b.job;
2106:
2107: begin

Line 3023: from user_jobs

3019: -- Removed check for concurrent request in order to make this work in Standalone too
3020: -- Originally the control queue cleanup is set up as DBMS job by wfctqcln.sql.
3021: -- Check if the dbms_job is running
3022: select count(1) into job_count
3023: from user_jobs
3024: where upper(what) like '%WF_BES_CLEANUP.CLEANUP_SUBSCRIBERS%'
3025: and broken = 'N';
3026:
3027: if (job_count = 0) then