APPS.XNP_CVU_PKG dependencies on XNP_SERVICE_PROVIDERS
Line 422: FROM xnp_service_providers
418: INTO v_invalid_sp_name
419: FROM dual
420: WHERE EXISTS
421: (SELECT 'X' 422: FROM xnp_service_providers 423: WHERE code = v_local_sp_name
424: AND active_flag = 'Y');
425:
426: EXCEPTION when no_data_found then
Line 866: FROM xnp_service_providers sp
862: v_first_time BOOLEAN := TRUE;
863:
864: CURSOR c_sp IS
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);