[Home] [Help]
16872: END IF;
16873: select count(*) into l_feeder_count
16874: from msc_system_items
16875: where plan_id in ( select plans.plan_id input_plan_id
16876: from msc_plan_schedules sched,
16877: msc_designators md,
16878: msc_plans plans
16879: where sched.plan_id = x_plan_info_rec.plan_id
16880: and sched.input_type = 1