APPS.MSC_UTIL dependencies on MSC_APPS_INSTANCES

Line 1284: FROM msc_apps_instances

1280: l_profile CONSTANT VARCHAR2(80) := 'GMP_APS_CONFIG_LEVEL';
1281:
1282: CURSOR db_cur(pv_instance_id NUMBER) IS
1283: SELECT DECODE(M2A_dblink,null,' ','@'||M2A_dblink)
1284: FROM msc_apps_instances
1285: WHERE instance_id = pv_instance_id;
1286:
1287: l_level NUMBER;
1288: l_level_dest NUMBER;

Line 1358: FROM MSC_APPS_INSTANCES

1354:
1355: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
1356: SELECT APPS_VER
1357: INTO v_apps_ver
1358: FROM MSC_APPS_INSTANCES
1359: WHERE INSTANCE_ID= pINSTANCE_ID;
1360:
1361: IF (v_apps_ver<> -1 AND v_apps_ver < MSC_UTIL.G_APPS115) THEN --bug#5684183 (bcaru)
1362: MSC_UTIL.G_COLLECT_SRP_DATA := 'N' ; --SRP not supported for version < 12.1