DBA Data[Home] [Help]

APPS.ITA_NOTIFICATION_PKG dependencies on FND_LOOKUP_VALUES

Line 275: from FND_LOOKUP_VALUES

271: setup_gp.HIERARCHY_LEVEL,
272: decode(setup_gp.SETUP_GROUP_CODE, 'FND.FND_PROFILE_OPTION_VALUES',
273: (
274: select MEANING
275: from FND_LOOKUP_VALUES
276: where
277: LANGUAGE = USERENV('LANG') and
278: VIEW_APPLICATION_ID = 438 and
279: LOOKUP_TYPE = 'ITA_PROFILE_LEVEL_ID' and

Line 319: from FND_LOOKUP_VALUES

315:
316:
317: -- Also, ignore profile option changes at levels other than Site.
318: select MEANING into m_org_type_test
319: from FND_LOOKUP_VALUES
320: where
321: LANGUAGE = USERENV('LANG') and
322: VIEW_APPLICATION_ID = 438 and
323: LOOKUP_TYPE = 'ITA_PROFILE_LEVEL_ID' and