APPS.HR_PARAMETER_HRMNPSUM dependencies on FND_NEW_MESSAGES

Line 159: from fnd_new_messages

155:
156: cursor c_geog_level is
157: select '1' lev_code,
158: message_text lev
159: from fnd_new_messages
160: where message_name = 'HR_BIS_AREA'
161: and application_id = 800
162: and language_code = userenv('LANG')
163: union

Line 166: from fnd_new_messages

162: and language_code = userenv('LANG')
163: union
164: select '2' lev_code,
165: message_text lev
166: from fnd_new_messages
167: where message_name = 'HR_BIS_COUNTRY'
168: and application_id = 800
169: and language_code = userenv('LANG')
170: union

Line 173: from fnd_new_messages

169: and language_code = userenv('LANG')
170: union
171: select '3' lev_code,
172: message_text lev
173: from fnd_new_messages
174: where message_name = 'HR_BIS_REGION'
175: and application_id = 800
176: and language_code = userenv('LANG');
177:

Line 335: from fnd_new_messages

331:
332: cursor c_view_by is
333: select message_name,
334: message_text view_by
335: from fnd_new_messages
336: where message_name = 'HR_BIS_TIME'
337: and application_id = 800
338: and language_code = userenv('LANG')
339: union

Line 342: from fnd_new_messages

338: and language_code = userenv('LANG')
339: union
340: select message_name,
341: message_text view_by
342: from fnd_new_messages
343: where message_name = 'HR_BIS_GEOGRAPHY'
344: and application_id = 800
345: and language_code = userenv('LANG')
346: union

Line 349: from fnd_new_messages

345: and language_code = userenv('LANG')
346: union
347: select message_name,
348: message_text view_by
349: from fnd_new_messages
350: where message_name = 'HR_BIS_PRODUCT'
351: and application_id = 800
352: and language_code = userenv('LANG')
353: order by 1 desc;