APPS.OKC_SPN_PVT dependencies on OKX_UNITS_OF_MEASURE_V

Line 325: CURSOR uom_pk_csr (p_uom_code IN okx_units_of_measure_v.uom_code%type) IS

321: x_return_status OUT NOCOPY VARCHAR2,
322: p_spnv_rec IN spnv_rec_type) IS
323: item_not_found_error EXCEPTION;
324: l_row_notfound BOOLEAN := TRUE;
325: CURSOR uom_pk_csr (p_uom_code IN okx_units_of_measure_v.uom_code%type) IS
326: SELECT '1'
327: FROM OKC_Timeunit_v
328: WHERE uom_code = p_uom_code
329: and nvl(inactive_date,trunc(sysdate)) >= trunc(sysdate);