198: from dual;
199: --
200: cursor csr_prog_name(short_name in varchar2) is
201: select user_concurrent_program_name
202: from fnd_concurrent_programs_tl
203: where concurrent_program_id =
204: (
205: select concurrent_program_id
206: from fnd_concurrent_programs
202: from fnd_concurrent_programs_tl
203: where concurrent_program_id =
204: (
205: select concurrent_program_id
206: from fnd_concurrent_programs
207: where concurrent_program_name = short_name
208: and application_id in (800, 801)
209: )
210: and language = userenv('LANG') ;