APPS.MSD_VALIDATE dependencies on MSC_APPS_INSTANCES

Line 187: FROM MSC_APPS_INSTANCES

183: INSTANCE_TYPE, apps_ver,
184: DECODE( A2M_DBLINK, NULL, NULL_DBLINK, '@'||A2M_DBLINK||' ') A2M_DBLINK,
185: instance_code,
186: instance_id
187: FROM MSC_APPS_INSTANCES
188: where instance_id = decode(c_instance_id, -1, instance_id,
189: 0, instance_id,
190: c_instance_id);
191:

Line 253: FROM MSC_APPS_INSTANCES

249: INTO v_m2a_dblink,
250: v_instance_type, v_apps_ver,
251: v_a2m_dblink,
252: v_instance_code
253: FROM MSC_APPS_INSTANCES
254: WHERE INSTANCE_ID= p_INSTANCE_ID;
255:
256:
257: EXCEPTION