APPS.JTF_TTY_NA_TERRGP dependencies on WF_ACTIVITIES_VL

Line 2267: FROM wf_activities_vl

2263:
2264: IF (p_workflow_item_type IS NOT NULL) THEN
2265: SELECT COUNT(name)
2266: INTO p_workflow_count
2267: FROM wf_activities_vl
2268: WHERE item_type = p_workflow_item_type
2269: AND TYPE = 'PROCESS'
2270: AND TRUNC(NVL(end_date,SYSDATE)) >= TRUNC(SYSDATE);
2271: IF (p_workflow_count > 0) THEN

Line 2274: FROM wf_activities_vl

2270: AND TRUNC(NVL(end_date,SYSDATE)) >= TRUNC(SYSDATE);
2271: IF (p_workflow_count > 0) THEN
2272: SELECT name
2273: INTO p_workflow_process_name
2274: FROM wf_activities_vl
2275: WHERE item_type = p_workflow_item_type
2276: AND TYPE = 'PROCESS'
2277: AND TRUNC(NVL(end_date,SYSDATE)) >= TRUNC(SYSDATE)
2278: AND ROWNUM < 2 ;