APPS.ICX_REQ_CATEGORIES dependencies on ICX_RELATED_CATEGORIES_VAL_V

Line 139: from icx_related_categories_val_v

135: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');
136:
137:
138: select count(-1) into v_no_of_children
139: from icx_related_categories_val_v
140: where CATEGORY_ID = v_node_id
141: and CATEGORY_SET_ID = v_category_set_id /* new*/
142: and RELATIONSHIP_TYPE <> 'TOP';
143: if v_no_of_children > 0 then

Line 282: from icx_related_categories_val_v

278: WHERE functional_area_id = 2;
279:
280: cursor getAnyTop(v_category_set_id number) is
281: select category_id
282: from icx_related_categories_val_v
283: where relationship_type = 'TOP'
284: and category_set_id = v_category_set_id;
285:
286:

Line 351: from icx_related_categories_val_v

347:
348: v_p_where := icx_call.encrypt2(v_node_id || '*' || v_org || '*' || v_name || '**]');
349:
350: select count(-1) into v_no_of_children
351: from icx_related_categories_val_v
352: where CATEGORY_ID = v_node_id
353: and CATEGORY_SET_ID = v_cat_set_id
354: and RELATIONSHIP_TYPE <> 'TOP';
355: