APPS.MSC_SNAPSHOT_PK dependencies on MSC_APPS_INSTANCES

Line 1545: from msc_apps_instances

1541: return NUMBER IS
1542: l_org_id NUMBER;
1543: BEGIN
1544: select nvl(validation_org_id,-1) into l_org_id
1545: from msc_apps_instances
1546: where instance_id = p_sr_instance_id;
1547: return l_org_id;
1548: EXCEPTION WHEN OTHERS THEN
1549: return -1;