DBA Data[Home] [Help]

APPS.XNP_CORE dependencies on XNP_SERVICE_AREAS

Line 288: ,xnp_service_areas sa

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;
292: BEGIN