DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_TYPES_PKG dependencies on FND_LANGUAGES

Line 118: from FND_LANGUAGES L

114: hz_utility_v2pub.program_application_id,
115: hz_utility_v2pub.request_id,
116: L.LANGUAGE_CODE,
117: userenv('LANG')
118: from FND_LANGUAGES L
119: where L.INSTALLED_FLAG in ('I', 'B')
120: and not exists
121: (select NULL
122: from HZ_GEOGRAPHY_TYPES_TL T

Line 454: from HZ_GEOGRAPHY_TYPES_TL B, FND_LANGUAGES L

450: B.LAST_UPDATE_LOGIN,
451: L.LANGUAGE_CODE,
452: B.SOURCE_LANG,
453: B.CREATED_BY_MODULE
454: from HZ_GEOGRAPHY_TYPES_TL B, FND_LANGUAGES L
455: where L.INSTALLED_FLAG in ('I', 'B')
456: and B.LANGUAGE = userenv('LANG')
457: and not exists
458: (select NULL

Line 657: FROM FND_LANGUAGES L

653: hz_utility_v2pub.program_application_id,
654: hz_utility_v2pub.request_id,
655: L.LANGUAGE_CODE,
656: USERENV('LANG')
657: FROM FND_LANGUAGES L
658: WHERE L.INSTALLED_FLAG in ('I', 'B')
659: AND NOT EXISTS (SELECT NULL
660: FROM HZ_GEOGRAPHY_TYPES_TL T
661: WHERE T.GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE