APPS.PER_STARTUP_PERSON_TYPES_PKG dependencies on FND_LANGUAGES

Line 100: from fnd_languages l

96: ,1
97: ,1
98: ,1
99: ,sysdate
100: from fnd_languages l
101: where L.INSTALLED_FLAG in ('I', 'B');
102:
103: end if;
104: end loop;

Line 181: from per_person_types ppt, fnd_languages l

177: ,1
178: ,1
179: ,1
180: ,sysdate
181: from per_person_types ppt, fnd_languages l
182: where L.INSTALLED_FLAG in ('I', 'B')
183: and x_seeded_person_type_key = ppt.seeded_person_type_key
184: and x_system_person_type = ppt.system_person_type
185: and x_user_person_type = ppt.user_person_type

Line 222: from FND_LANGUAGES L

218: X_SYSTEM_PERSON_TYPE,
219: X_CURRENT_APPLICANT_FLAG,
220: L.LANGUAGE_CODE,
221: userenv('LANG')
222: from FND_LANGUAGES L
223: where L.INSTALLED_FLAG in ('I', 'B')
224: and not exists (
225: select null
226: from per_startup_person_types_tl

Line 499: from PER_STARTUP_PERSON_TYPES_TL B, FND_LANGUAGES L

495: B.SYSTEM_PERSON_TYPE,
496: B.CURRENT_APPLICANT_FLAG,
497: L.LANGUAGE_CODE,
498: B.SOURCE_LANG
499: from PER_STARTUP_PERSON_TYPES_TL B, FND_LANGUAGES L
500: where L.INSTALLED_FLAG in ('B','I')
501: and B.LANGUAGE = userenv('LANG')
502: and not exists
503: (select NULL