[Home] [Help]
865: SELECT sp_id, code, sp_type, name
866: FROM xnp_service_providers sp
867: WHERE NOT EXISTS
868: (SELECT 1
869: FROM xnp_sp_adapters spa
870: WHERE sp.sp_id = spa.sp_id);
871: BEGIN
872: FOR rec IN c_sp
873: LOOP