858: ,L.LANGUAGE_CODE
859: ,userenv('LANG')
860: ,p_Anal_Opt_Rec.Bsc_Option_Name
861: ,p_Anal_Opt_Rec.Bsc_Option_Help
862: from FND_LANGUAGES L
863: where L.INSTALLED_FLAG in ('I', 'B')
864: and not exists
865: (select NULL
866: from BSC_KPI_ANALYSIS_OPTIONS_TL T
1720: ,L.LANGUAGE_CODE
1721: ,userenv('LANG')
1722: ,p_Anal_Opt_Rec.Bsc_Measure_Long_Name
1723: ,p_Anal_Opt_Rec.Bsc_Measure_Help
1724: from FND_LANGUAGES L
1725: where L.INSTALLED_FLAG in ('I', 'B')
1726: and not exists
1727: (select NULL
1728: from BSC_KPI_ANALYSIS_MEASURES_TL T