29: ** Get sequence value for demand_id and parent_demand_id
30: */
31: select mtl_demand_s.nextval
32: into l_demand_id_dmd
33: from dual;
34:
35: select mtl_demand_s.nextval
36: into l_demand_id_rsv
37: from dual;
33: from dual;
34:
35: select mtl_demand_s.nextval
36: into l_demand_id_rsv
37: from dual;
38:
39: select demand_source_type_id
40: into l_demand_source_type_id
41: from mtl_reservations