APPS.MSC_EXP_WF dependencies on MSC_APPS_INSTANCES

Line 594: FROM msc_apps_instances

590:
591: CURSOR DB_LINK_C(sr_instance_id in number) IS
592: SELECT decode(M2A_dblink,null,' ','@'||M2A_dblink),
593: decode(A2M_dblink,null,' ','@'||A2M_dblink)
594: FROM msc_apps_instances
595: WHERE instance_id = sr_instance_id;
596:
597: l_cursor varchar2(30);
598:

Line 2154: FROM msc_apps_instances

2150: delete_activities_c DelExpType;
2151: -- Note that the null is important for this instance
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