DBA Data[Home] [Help]

APPS.PER_PMP_MASS_NOTIFICATION dependencies on FND_NEW_MESSAGES

Line 305: FROM fnd_new_messages m

301: where orig_system_id = p_person_id
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;