DBA Data[Home] [Help]

APPS.HR_BPL_MESSAGE dependencies on FND_NEW_MESSAGES

Line 94: from fnd_new_messages m, fnd_application a

90: return varchar2 is MSG varchar2(2000) := NULL;
91:
92: cursor c1(NAME_ARG varchar2) is
93: select message_text
94: from fnd_new_messages m, fnd_application a
95: where NAME_ARG = m.message_name
96: and m.language_code = g_mes_lng
97: and APPIN = a.application_short_name
98: and m.application_id = a.application_id;

Line 101: from fnd_new_messages m, fnd_application a

97: and APPIN = a.application_short_name
98: and m.application_id = a.application_id;
99: cursor c2(NAME_ARG varchar2) is
100: select message_text
101: from fnd_new_messages m, fnd_application a
102: where NAME_ARG = m.message_name
103: and 'US' = m.language_code
104: and APPIN = a.application_short_name
105: and m.application_id = a.application_id;