234: END IF; -- end of street rep check
235:
236: SELECT Greatest(l_street_exist,l_direct_exist)
237: INTO x_child_street_exist 238: FROM dual; 239:
240: END down_one_level;
241:
242: --======================================================================