328: SELECT
329: node_id,
330: node_name,
331: node_description 332: FROM fnd_dm_nodes 333: WHERE node_name like p_find_criteria||'%'
334: ORDER BY node_name;
335:
336: BEGIN
Line 345: FROM fnd_dm_nodes
341: IF (p_titles_only = 'N') THEN
342:
343: SELECT COUNT(*)
344: INTO l_row_count 345: FROM fnd_dm_nodes 346: WHERE node_name like p_find_criteria||'%';
347:
348: END IF;
349: