APPS.OE_ERROR_WF dependencies on WF_ACTIVITIES_VL

Line 1185: FROM WF_Activities_VL

1181: oe_debug_pub.add('Entering Get_Activity_Display_Name');
1182: END IF;
1183: SELECT display_name
1184: INTO l_activity_display_name
1185: FROM WF_Activities_VL
1186: WHERE Name = p_activity_name
1187: AND Item_Type = p_activity_item_type
1188: AND Version = (SELECT max(version)
1189: FROM WF_Activities_VL

Line 1189: FROM WF_Activities_VL

1185: FROM WF_Activities_VL
1186: WHERE Name = p_activity_name
1187: AND Item_Type = p_activity_item_type
1188: AND Version = (SELECT max(version)
1189: FROM WF_Activities_VL
1190: WHERE Name = p_activity_name
1191: AND Item_Type = p_activity_item_type);
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add('Exiting Get_Activity_Display_Name with result: ' ||l_activity_display_name);

Line 2495: SELECT DISPLAY_NAME into l_act_display_name FROM wf_activities_vl

2491: AND ENABLED_FLAG='Y'
2492: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);
2493:
2494: IF p_activity_name is not null then
2495: SELECT DISPLAY_NAME into l_act_display_name FROM wf_activities_vl
2496: WHERE ROW_ID IN (SELECT MAX(ROWID) FROM WF_ACTIVITIES WA
2497: WHERE WA.TYPE NOT IN ('PROCESS','FOLDER')
2498: AND EXISTS (SELECT ACTIVITY_NAME FROM WF_PROCESS_ACTIVITIES WPA
2499: WHERE WA.NAME = WPA.ACTIVITY_NAME