DBA Data[Home] [Help]

APPS.OKC_ISE_PVT dependencies on OKX_UNITS_OF_MEASURE_V

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

828: x_return_status OUT NOCOPY VARCHAR2,
829: p_isev_rec IN isev_rec_type) IS
830: item_not_found_error EXCEPTION;
831: l_row_notfound BOOLEAN := TRUE;
832: CURSOR uom_pk_csr (p_uom_code IN okx_units_of_measure_v.uom_code%type) IS
833: SELECT '1'
834: FROM OKC_Timeunit_v
835: WHERE uom_code = p_uom_code
836: and nvl(inactive_date,trunc(sysdate)) >= trunc(sysdate);