APPS.ICX_POR_CTX_DESC dependencies on ICX_CAT_DESCRIPTORS_TL

Line 276: from icx_cat_descriptors_tl des

272: WHERE cat.language = p_lang
273: AND cat.rt_category_id <> 0
274: AND cat.type = 2
275: AND exists (select 'X'
276: from icx_cat_descriptors_tl des
277: where des.rt_category_id = cat.rt_category_id
278: and des.language = cat.language
279: and des.searchable = 1)
280: AND exists (select 'X'

Line 365: from icx_cat_descriptors_tl des

361: WHERE cat.language = p_lang
362: AND cat.rt_category_id <> 0
363: AND cat.type = 2
364: AND exists (select 'X'
365: from icx_cat_descriptors_tl des
366: where des.rt_category_id = cat.rt_category_id
367: and des.language = cat.language
368: and des.searchable = 1)
369: AND exists (select 'X'

Line 821: FROM ICX_CAT_DESCRIPTORS_TL

817: INTO vCatTableExists
818: FROM DUAL
819: WHERE EXISTS
820: (SELECT 1
821: FROM ICX_CAT_DESCRIPTORS_TL
822: WHERE RT_CATEGORY_ID=p_category_id
823: AND CLASS = 'POM_CAT_ATTR');
824: EXCEPTION
825: WHEN NO_DATA_FOUND THEN

Line 857: FROM ICX_CAT_DESCRIPTORS_TL

853: INTO vSearchableExists
854: FROM DUAL
855: WHERE EXISTS
856: (SELECT 1
857: FROM ICX_CAT_DESCRIPTORS_TL
858: WHERE RT_CATEGORY_ID=p_category_id
859: AND CLASS = 'POM_CAT_ATTR'
860: AND SEARCHABLE = 1);
861: EXCEPTION