[Home] [Help]
47: --
48:
49: IF X_hierarchy_id IS NULL THEN
50:
51: -- X_Hierarchy_ID := cn_dim_hierarchies_s.nextval;
52:
53: SELECT cn_dim_hierarchies_s.nextval
54: INTO X_hierarchy_id FROM dual;
55:
49: IF X_hierarchy_id IS NULL THEN
50:
51: -- X_Hierarchy_ID := cn_dim_hierarchies_s.nextval;
52:
53: SELECT cn_dim_hierarchies_s.nextval
54: INTO X_hierarchy_id FROM dual;
55:
56: END IF;
57: