APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_APPS_INSTANCES

Line 252: FROM msc_apps_instances

248: IS
249: BEGIN
250: SELECT decode ( m2a_dblink, null, '', '@' || m2a_dblink)
251: INTO p_dblink
252: FROM msc_apps_instances
253: WHERE instance_id = p_sr_instance_id;
254:
255: EXCEPTION
256: WHEN OTHERS THEN

Line 298: FROM msc_apps_instances

294: IS
295: BEGIN
296: SELECT decode ( a2m_dblink, null, '', '@' || a2m_dblink)
297: INTO p_dblink
298: FROM msc_apps_instances
299: WHERE instance_id = p_sr_instance_id;
300:
301: EXCEPTION
302: WHEN OTHERS THEN

Line 332: FROM msc_apps_instances

328: p_instance_code,
329: p_apps_ver,
330: p_dgmt,
331: p_instance_type
332: FROM msc_apps_instances
333: WHERE instance_id= p_sr_instance_id;
334: EXCEPTION
335: WHEN OTHERS THEN
336: retcode := -1 ;

Line 1419: EXECUTE IMMEDIATE 'select instance_type from msc_apps_instances where instance_id = :1'

1415: THEN
1416: RETURN 2;
1417: END IF;
1418:
1419: EXECUTE IMMEDIATE 'select instance_type from msc_apps_instances where instance_id = :1'
1420: INTO x_instance_type
1421: USING p_sr_instance_id;
1422:
1423: IF (x_instance_type IN (1,2,4))