APPS.XNP_CORE dependencies on XNP_SERVICE_PROVIDERS

Line 80: FROM xnp_service_providers

76: IS
77:
78: CURSOR c_sp_id IS
79: SELECT sp_id
80: FROM xnp_service_providers
81: WHERE code = p_sp_name
82: AND active_flag = 'Y';
83:
84:

Line 144: FROM xnp_service_providers

140: IS
141:
142: CURSOR c_sp_name IS
143: SELECT code
144: FROM xnp_service_providers
145: WHERE sp_id = p_sp_id;
146:
147: BEGIN
148:

Line 287: FROM xnp_service_providers sp

283: CONNECT BY PRIOR parent_geo_area_id = child_geo_area_id;
284:
285: CURSOR c_nrc_id(l_geo_id IN NUMBER) IS
286: SELECT sp.sp_id
287: FROM xnp_service_providers sp
288: ,xnp_service_areas sa
289: WHERE sp.sp_id = sa.sp_id
290: AND sp.sp_type = 'NRC'
291: AND sa.geo_area_id = l_geo_id;