APPS.MSC_WS_COLLECTIONS dependencies on MSC_APPS_INSTANCES

Line 1711: FROM msc_apps_instances

1707: l_val_instance_id NUMBER;
1708: BEGIN
1709: BEGIN
1710: SELECT instance_id INTO l_val_instance_id
1711: FROM msc_apps_instances
1712: WHERE instance_id = INST_ID
1713: AND instance_type IN (1,2,4) and enable_flag=1;
1714: END;
1715:

Line 1911: from msc_apps_instances

1907: return TRUE;
1908: end if;
1909:
1910: select a2m_dblink into dbLink
1911: from msc_apps_instances
1912: where instance_id = InstanceId;
1913:
1914: select DECODE(dbLink, NULL,'', '@' || dbLink) into dbLink2 from dual;
1915: tableName := 'oe_transaction_types_tl' || dbLink2;