APPS.WF_ACTIVITIES_VL_PUB dependencies on WF_RUNNABLE_PROCESSES_V

Line 1252: ** outer join on the WF_RUNNABLE_PROCESSES_V view and that

1248: /*
1249: ** Select whether this process is runnable or not. This is
1250: ** the most optimal method of getting this info rather than
1251: ** doing this in the view since you would have to do an
1252: ** outer join on the WF_RUNNABLE_PROCESSES_V view and that
1253: ** will cause a full table scan on activities.
1254: */
1255: SELECT count(*)
1256: INTO l_runnable_process

Line 1257: FROM WF_RUNNABLE_PROCESSES_V

1253: ** will cause a full table scan on activities.
1254: */
1255: SELECT count(*)
1256: INTO l_runnable_process
1257: FROM WF_RUNNABLE_PROCESSES_V
1258: WHERE item_type = p_wf_activities_vl_tbl(l_activity_record_num).item_type
1259: AND process_name = p_wf_activities_vl_tbl(l_activity_record_num).name;
1260:
1261: IF (l_runnable_process > 0) THEN