DBA Data[Home] [Help]

APPS.PER_PMP_MASS_NOTIFICATION dependencies on FND_APPLICATION

Line 306: ,fnd_application a

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);