APPS.PER_ASS_STATUSES_PKG dependencies on FND_LANGUAGES

Line 280: from FND_LANGUAGES L, FND_LANGUAGES B

276: P_LAST_UPDATED_BY,
277: P_LAST_UPDATE_LOGIN,
278: P_CREATED_BY,
279: P_CREATION_DATE
280: from FND_LANGUAGES L, FND_LANGUAGES B
281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.INSTALLED_FLAG = 'B';
283: -- MLS end
284: END INSERT_AMENDS;

Line 454: from FND_LANGUAGES L

450: X_CREATED_BY,
451: X_CREATION_DATE,
452: L.LANGUAGE_CODE,
453: userenv('LANG')
454: from FND_LANGUAGES L
455: where L.INSTALLED_FLAG in ('I', 'B')
456: and not exists
457: (select NULL
458: from PER_ASSIGNMENT_STATUS_TYPES_TL T

Line 854: from PER_ASSIGNMENT_STATUS_TYPES_TL B, FND_LANGUAGES L

850: B.CREATED_BY,
851: B.CREATION_DATE,
852: L.LANGUAGE_CODE,
853: B.SOURCE_LANG
854: from PER_ASSIGNMENT_STATUS_TYPES_TL B, FND_LANGUAGES L
855: where L.INSTALLED_FLAG in ('I', 'B')
856: and B.LANGUAGE = userenv('LANG')
857: and not exists
858: (select NULL

Line 911: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L

907: B.CREATED_BY,
908: B.CREATION_DATE,
909: L.LANGUAGE_CODE,
910: B.SOURCE_LANG
911: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L
912: where L.INSTALLED_FLAG in ('I', 'B')
913: and B.LANGUAGE = userenv('LANG')
914: and not exists
915: (select NULL