APPS.MSC_WF_ALLOC_ATP dependencies on MSC_PLANS

Line 212: msc_plans p

208: IS
209: SELECT distinct pl.user_name, p.compile_designator
210: FROM msc_planners pl,
211: msc_system_items sys,
212: msc_plans p
213: WHERE sys.plan_id = p_plan_id
214: AND sys.organization_id = p_organization_id
215: AND sys.sr_instance_id = p_instance_id
216: AND sys.sr_inventory_item_id = p_inventory_item_id

Line 538: msc_plans p

534: IS
535: SELECT distinct pl.user_name, p.compile_designator
536: FROM msc_planners pl,
537: msc_system_items sys,
538: msc_plans p
539: WHERE sys.plan_id = p_plan_id
540: AND sys.organization_id = p_organization_id
541: AND sys.sr_instance_id = p_instance_id
542: AND sys.sr_inventory_item_id = p_inventory_item_id