APPS.ORACLECONFIGURE dependencies on ICX_REGIONS

Line 275: for x in (select * from icx_regions where parent_region_id = p_region_id) loop

271: l_region_child_count number;
272:
273: begin
274:
275: for x in (select * from icx_regions where parent_region_id = p_region_id) loop
276:
277: deletePagePrivate(x.region_id);
278:
279: end loop;

Line 281: delete from icx_regions

277: deletePagePrivate(x.region_id);
278:
279: end loop;
280:
281: delete from icx_regions
282: where region_id = p_region_id;
283:
284: end deletePagePrivate;
285: