683: l_name := NULL;
684: ELSE
685: select version
686: into l_version
687: from wf_activities
688: where name =p_name
689: and item_type = p_type
690: and nvl(begin_date, sysdate) <= sysdate
691: and nvl(end_date, sysdate) >= sysdate
692: and type = 'PROCESS';
693:
694: select display_name
695: into l_name
696: from wf_activities_tl
697: where version = l_version
698: and name = p_name
699: and item_type = p_type
700: and language = nvl(userenv('LANG'),'US');