APPS.ICX_CAT_POPULATE_CTXSTRING_PVT dependencies on FND_LANGUAGES

Line 799: AND cat.language = (SELECT language_code FROM fnd_languages WHERE installed_flag = 'B')

795: CURSOR getCategoriesCsr(p_internal_request_id NUMBER) IS
796: SELECT cat.rt_category_id
797: FROM icx_cat_categories_tl cat
798: WHERE cat.type = 2
799: AND cat.language = (SELECT language_code FROM fnd_languages WHERE installed_flag = 'B')
800: AND EXISTS (SELECT 'atleast one searchable descriptor'
801: FROM icx_cat_attributes_tl att
802: where att.rt_category_id = cat.rt_category_id
803: and att.language = cat.language