APPS.ICX_CAT_BUILD_CTX_SQL_PVT dependencies on ICX_CAT_ATTRIBUTES_TL

Line 21: FROM icx_cat_attributes_tl

17: BEGIN
18: l_err_loc := 100;
19: SELECT searchable, section_tag
20: INTO p_searchable, p_section_tag
21: FROM icx_cat_attributes_tl
22: WHERE key = p_attribute_key
23: AND rownum = 1;
24:
25: l_err_loc := 200;

Line 57: FROM icx_cat_attributes_tl

53: IS
54: CURSOR getSearchableMetadataCsr(p_category_id NUMBER) IS
55: SELECT attribute_id, key, type,
56: section_tag, stored_in_table, stored_in_column
57: FROM icx_cat_attributes_tl
58: WHERE rt_category_id = p_category_id
59: AND language = ( SELECT language_code FROM fnd_languages WHERE installed_flag = 'B')
60: AND searchable = 1
61: ORDER BY attribute_id;