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);