APPS.OE_VALIDATE_WF dependencies on WF_ACTIVITIES_TL

Line 46: FROM wf_activities_tl wa

42: oe_debug_pub.add('Entering Display_Name for process : '||l_process,5);
43:
44: SELECT DISTINCT wa.name, wa.display_name
45: INTO l_process_name, l_display_name
46: FROM wf_activities_tl wa
47: WHERE wa.item_type = l_item_type
48: AND wa.name = l_process
49: AND wa.language = userenv('LANG')
50: AND wa.version =

Line 52: FROM wf_activities_tl p1

48: AND wa.name = l_process
49: AND wa.language = userenv('LANG')
50: AND wa.version =
51: ( SELECT MAX(p1.version)
52: FROM wf_activities_tl p1
53: WHERE p1.item_type = wa.item_type
54: AND p1.name = wa.name
55: AND p1.language = wa.language
56: );