[Home] [Help]
302: and orig_system = 'PER';
303: CURSOR csr_appl_name(p_message_name VARCHAR2) IS
304: SELECT a.application_short_name
305: FROM fnd_new_messages m
306: ,fnd_application a
307: WHERE m.message_name = p_message_name
308: AND m.language_code = USERENV('LANG')
309: AND m.application_id = a.application_id;
310: l_appl_short_name varchar2(30);