DBA Data[Home] [Help]

APPS.PER_ASS_STATUSES_PKG dependencies on FND_LANGUAGES

Line 322: from FND_LANGUAGES L, FND_LANGUAGES B

318: P_LAST_UPDATED_BY,
319: P_LAST_UPDATE_LOGIN,
320: P_CREATED_BY,
321: P_CREATION_DATE
322: from FND_LANGUAGES L, FND_LANGUAGES B
323: where L.INSTALLED_FLAG in ('I', 'B')
324: and B.INSTALLED_FLAG = 'B';
325: -- MLS end
326: END INSERT_AMENDS;

Line 516: from FND_LANGUAGES L

512: X_CREATED_BY,
513: X_CREATION_DATE,
514: L.LANGUAGE_CODE,
515: userenv('LANG')
516: from FND_LANGUAGES L
517: where L.INSTALLED_FLAG in ('I', 'B')
518: and not exists
519: (select NULL
520: from PER_ASSIGNMENT_STATUS_TYPES_TL T

Line 941: from PER_ASSIGNMENT_STATUS_TYPES_TL B, FND_LANGUAGES L

937: B.CREATED_BY,
938: B.CREATION_DATE,
939: L.LANGUAGE_CODE,
940: B.SOURCE_LANG
941: from PER_ASSIGNMENT_STATUS_TYPES_TL B, FND_LANGUAGES L
942: where L.INSTALLED_FLAG in ('I', 'B')
943: and B.LANGUAGE = userenv('LANG')
944: and not exists
945: (select NULL

Line 998: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L

994: B.CREATED_BY,
995: B.CREATION_DATE,
996: L.LANGUAGE_CODE,
997: B.SOURCE_LANG
998: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L
999: where L.INSTALLED_FLAG in ('I', 'B')
1000: and B.LANGUAGE = userenv('LANG')
1001: and not exists
1002: (select NULL