48: from mtl_cc_subinventories
49: where cycle_count_header_id = p_cycle_count_header_id
50: and subinventory = p_subinventory_code;
51:
52: select mtl_cc_schedule_requests_s.nextval
53: into l_cycle_count_schedule_id
54: from dual;
55:
56: IF l_subs_ct = 0 then
90: X_Control_Group_Flag => 2
91: );
92: end if;
93:
94: insert into mtl_cc_schedule_requests (
95: cycle_count_schedule_id ,
96: last_update_date ,
97: last_updated_by ,
98: creation_date ,