APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_APPS_INSTANCES

Line 237: FROM msc_apps_instances

233: IS
234: BEGIN
235: SELECT decode ( m2a_dblink, null, '', '@' || m2a_dblink)
236: INTO p_dblink
237: FROM msc_apps_instances
238: WHERE instance_id = p_sr_instance_id;
239:
240: EXCEPTION
241: WHEN OTHERS THEN

Line 272: FROM msc_apps_instances

268: p_instance_code,
269: p_apps_ver,
270: p_dgmt,
271: p_instance_type
272: FROM msc_apps_instances
273: WHERE instance_id= p_sr_instance_id;
274: EXCEPTION
275: WHEN OTHERS THEN
276: retcode := -1 ;