APPS.CN_DIM_HIERARCHIES_PKG dependencies on DUAL

Line 23: FROM dual;

19: BEGIN
20: -- get the next pk from sequence
21: SELECT cn_dim_hierarchies_s.nextval
22: INTO x_dim_hierarchy_id
23: FROM dual;
24:
25: SELECT cn_hierarchy_nodes_s.nextval
26: INTO x_root_node
27: FROM dual;

Line 27: FROM dual;

23: FROM dual;
24:
25: SELECT cn_hierarchy_nodes_s.nextval
26: INTO x_root_node
27: FROM dual;
28:
29:
30:
31: -- create hierarchy