APPS.MSD_DEM_CTO dependencies on MSC_APPS_INSTANCES

Line 663: FROM msc_apps_instances

659: x_sql := x_sql || ' AND mb.organization_id = dem.sr_organization_id ';
660: ELSE
661: msd_dem_common_utilities.log_debug ('Get the validation org id for the instance');
662: SELECT validation_org_id INTO x_validation_org_id
663: FROM msc_apps_instances
664: WHERE instance_id = p_sr_instance_id;
665:
666: IF (x_validation_org_id IS NULL)
667: THEN