APPS.MSC_WS_OTM_BPEL dependencies on MSC_DESIGNATORS

Line 389: FROM msc_plans plans, msc_designators desig

385: order_type IN NUMBER,
386: status OUT nocopy varchar2) IS
387: cursor getProductionPlans is
388: SELECT plans.plan_id
389: FROM msc_plans plans, msc_designators desig
390: WHERE plans.curr_plan_type in (1,2,3,5)
391: AND plans.organization_id = desig.organization_id
392: AND plans.sr_instance_id = desig.sr_instance_id
393: AND plans.compile_designator = desig.designator