APPS.IBC_DIRECTORY_NODE_GRP dependencies on IBC_DIRECTORY_NODES_B

Line 43: FROM ibc_Directory_Nodes_b

39: IS
40: CURSOR C_Directory_Node IS
41: SELECT
42: Directory_Node_Code
43: FROM ibc_Directory_Nodes_b
44: WHERE Directory_Node_Code = P_Directory_Node_Rec.Directory_Node_Code
45: AND directory_node_id IN (SELECT child_dir_node_id
46: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id = P_parent_dir_node_id);
47:

Line 295: FROM ibc_Directory_Nodes_b

291:
292: CURSOR C_Directory_Node IS
293: SELECT
294: Directory_Node_Code
295: FROM ibc_Directory_Nodes_b
296: WHERE Directory_Node_Code = l_Directory_Node_Rec.Directory_Node_Code
297: AND directory_node_id IN (SELECT child_dir_node_id
298: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id= P_New_parent_node_id);
299:

Line 486: FROM ibc_Directory_Nodes_b

482:
483: CURSOR C_Directory_Node IS
484: SELECT
485: Directory_Node_Code
486: FROM ibc_Directory_Nodes_b
487: WHERE Directory_Node_Code = P_Directory_Node_Rec.Directory_Node_Code
488: AND directory_node_id IN (SELECT child_dir_node_id
489: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id= P_parent_dir_node_id)
490: AND Directory_Node_id <> P_Directory_Node_Rec.directory_node_id;

Line 682: FROM ibc_Directory_Nodes_b

678:
679: CURSOR C_Directory_Node IS
680: SELECT
681: Directory_Node_id
682: FROM ibc_Directory_Nodes_b
683: WHERE Directory_Node_id = p_Directory_Node_id;
684:
685: CURSOR C_Child_Nodes IS
686: SELECT LPAD(' ',3*(LEVEL-1)) || parent_dir_node_id,child_dir_node_id,directory_node_rel_id