413:
414: Select type
415: Into l_type
416: from fnd_new_messages a, 417: fnd_application b 418: where a.application_id = b.application_id
419: and a.language_code = USERENV('LANG')
420: and a.message_name = l_message_name
421: and b.application_short_name = l_app_id;