APPS.FND_NET_SERVICES dependencies on FND_DB_SERVICE_MEMBERS

Line 183: fnd_db_service_members c

179:
180: select count(*)
181: into l_valid_instance
182: from fnd_database_instances a, fnd_database_services b,
183: fnd_db_service_members c
184: where a.db_guid = l_db_guid
185: and a.Instance_Name = p_Instance_name
186: and a.db_guid = b.db_guid
187: and b.Service_Name = p_Service_Name

Line 2076: fnd_db_service_members c

2072: as
2073: cursor c1 is select a.service_name,b.Instance_Name,b.Instance_Number,
2074: c.instance_type
2075: from fnd_database_services a, fnd_database_instances b,
2076: fnd_db_service_members c
2077: where a.DB_Service_GUID = p_DB_Service_GUID
2078: and b.Instance_Guid = p_instance_guid
2079: and a.Db_Service_Guid = c.Db_Service_Guid
2080: and c.Instance_Guid = p_instance_guid ;

Line 2411: from fnd_db_service_members a

2407: for f_service in c5(f_instance.db_guid) loop
2408:
2409: select count(*)
2410: into l_service_member
2411: from fnd_db_service_members a
2412: where a.db_service_guid = f_service.db_service_guid
2413: and a.Instance_Guid = f_instance.Instance_Guid ;
2414:
2415: dbms_output.put_line ( fmtline('Service Name',20) ||

Line 2734: delete from fnd_db_service_members a

2730:
2731: delete from fnd_database_instances a
2732: where a.instance_guid = f_instance.instance_guid;
2733:
2734: delete from fnd_db_service_members a
2735: where a.db_guid = f_instance.db_guid
2736: and a.instance_guid = f_instance.instance_guid;
2737:
2738: delete from fnd_sids a

Line 2744: from fnd_db_service_members b

2740:
2741: delete from fnd_database_services a
2742: where a.db_guid = f_instance.db_guid
2743: and not exists ( select b.instance_guid
2744: from fnd_db_service_members b
2745: where b.db_service_guid = a.db_service_guid );
2746:
2747: delete from fnd_databases a
2748: where a.db_guid = f_instance.db_guid