DBA Data[Home] [Help]

APPS.MSC_WF_ALLOC_ATP dependencies on MSC_SYSTEM_ITEMS

Line 211: msc_system_items sys,

207: p_organization_id in number, p_instance_id in number)
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

Line 537: msc_system_items sys,

533: CURSOR PLANNER_C
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