APPS.IBC_UTILITIES_PVT dependencies on IBC_DIRECTORY_NODE_RELS

Line 1456: ibc_directory_node_rels dirrel

1452: AND UPPER(civtl.content_item_name) = UPPER(p_name)
1453: UNION
1454: SELECT 'DIRNODE', dirnodeb.directory_node_id
1455: FROM ibc_directory_nodes_b dirnodeb,
1456: ibc_directory_node_rels dirrel
1457: WHERE dirnodeb.directory_node_id = dirrel.child_dir_node_id
1458: AND dirrel.parent_dir_node_id = l_dir_node_id
1459: AND dirnodeb.directory_node_id <> NVL(p_chk_dir_node_id, -1)
1460: AND UPPER(dirnodeb.directory_node_code) = UPPER(p_name)

Line 1472: FROM ibc_directory_node_rels

1468: IF l_dir_node_id IS NULL THEN
1469: IF p_chk_dir_node_id IS NOT NULL THEN
1470: SELECT parent_dir_node_id
1471: INTO l_dir_node_id
1472: FROM ibc_directory_node_rels
1473: WHERE child_dir_node_id = p_chk_dir_node_id;
1474: ELSIF p_chk_content_item_id IS NOT NULL THEN
1475: SELECT directory_node_id
1476: INTO l_dir_node_id