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'
281: from icx_cat_category_items cit, icx_cat_items_b it
282: where cit.rt_category_id = cat.rt_category_id
283: and cit.rt_item_id = it.rt_item_id
284: and it.request_id = p_jobNum);
285: BEGIN
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'
370: from icx_cat_category_items cit
371: where cit.rt_category_id = cat.rt_category_id);
372: BEGIN
373: xErrLoc:=100;
374: --Debugging