APPS.FND_NET_SERVICES dependencies on FND_APPL_TOPS

Line 1798: from fnd_appl_tops a

1794: and a.path = AuxOracleHomePath;
1795:
1796: select a.appl_top_guid
1797: into l_Appl_Top_Guid
1798: from fnd_appl_tops a
1799: where a.node_id = l_node_id
1800: and a.path = ApplTopPath;
1801:
1802: -- Register Server

Line 2461: from fnd_appl_tops

2457: order by a.node_id,a.Internal,a.Server_type,a.name;
2458:
2459: cursor c3(p_appl_top_guid raw)
2460: is select name,Path,Shared
2461: from fnd_appl_tops
2462: where appl_top_guid = p_appl_top_guid;
2463:
2464: cursor c4(p_oracle_home_id raw)
2465: is select name,Path,Version,Description

Line 2830: delete from fnd_appl_tops a

2826: end if;
2827:
2828: if ( f_server.appl_top_guid is not null )
2829: then
2830: delete from fnd_appl_tops a
2831: where a.appl_top_guid = f_server.appl_top_guid
2832: and not exists ( select b.name
2833: from fnd_app_servers b
2834: where b.appl_top_guid = f_server.appl_top_guid