APPS.MSC_UTIL dependencies on MSC_APPS_INSTANCES

Line 1026: FROM msc_apps_instances

1022: l_profile CONSTANT VARCHAR2(80) := 'GMP_APS_CONFIG_LEVEL';
1023:
1024: CURSOR db_cur(pv_instance_id NUMBER) IS
1025: SELECT DECODE(M2A_dblink,null,' ','@'||M2A_dblink)
1026: FROM msc_apps_instances
1027: WHERE instance_id = pv_instance_id;
1028:
1029: l_level NUMBER;
1030: l_level_dest NUMBER;

Line 1100: FROM MSC_APPS_INSTANCES

1096:
1097: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
1098: SELECT APPS_VER
1099: INTO v_apps_ver
1100: FROM MSC_APPS_INSTANCES
1101: WHERE INSTANCE_ID= pINSTANCE_ID;
1102:
1103: IF (v_apps_ver<> -1 AND v_apps_ver < MSC_UTIL.G_APPS115) THEN --bug#5684183 (bcaru)
1104: MSC_UTIL.G_COLLECT_SRP_DATA := 'N' ; --SRP not supported for version < 12.1