APPS.MSC_EXP_WF dependencies on MSC_PLAN_ORGANIZATIONS

Line 2156: from msc_plan_organizations

2152: CURSOR instance_c(p_plan_id in varchar2) IS
2153: SELECT DEcode(m2a_dblink, null, ' ', '@' || m2a_dblink)
2154: FROM msc_apps_instances
2155: WHERE instance_id in (select sr_instance_id
2156: from msc_plan_organizations
2157: where plan_id = p_plan_id)
2158: UNION
2159: select ' '
2160: from dual;