DBA Data[Home] [Help]

APPS.CN_SCA_CRRULEATTR_PKG dependencies on FND_LANGUAGES

Line 597: from FND_LANGUAGES L

593: X_LAST_UPDATE_LOGIN,
594: X_SECURITY_GROUP_ID,
595: L.LANGUAGE_CODE,
596: userenv('LANG')
597: from FND_LANGUAGES L
598: where L.INSTALLED_FLAG in ('I', 'B')
599: and not exists
600: (select NULL
601: from CN_SCA_RULE_ATTRIBUTES_ALL_TL T

Line 921: from CN_SCA_RULE_ATTRIBUTES_ALL_TL B, FND_LANGUAGES L

917: B.LAST_UPDATE_LOGIN,
918: B.SECURITY_GROUP_ID,
919: L.LANGUAGE_CODE,
920: B.SOURCE_LANG
921: from CN_SCA_RULE_ATTRIBUTES_ALL_TL B, FND_LANGUAGES L
922: where L.INSTALLED_FLAG in ('I', 'B')
923: and B.LANGUAGE = userenv('LANG')
924: and not exists
925: (select NULL

Line 1034: FROM fnd_languages l

1030: user_id,
1031: 0,
1032: l.language_code,
1033: userenv('LANG')
1034: FROM fnd_languages l
1035: WHERE l.installed_flag IN ('I', 'B')
1036: AND NOT EXISTS
1037: (SELECT NULL
1038: FROM cn_sca_rule_attributes_all_tl t