APPS.FND_NET_SERVICES dependencies on FND_DB_SERVICE_MEMBERS

Line 185: fnd_db_service_members c

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

Line 2078: fnd_db_service_members c

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

Line 2413: from fnd_db_service_members a

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

Line 2736: delete from fnd_db_service_members a

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

Line 2746: from fnd_db_service_members b

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