DBA Data[Home] [Help]

APPS.OKC_TAL_PVT dependencies on OKX_UNITS_OF_MEASURE_V

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

586: x_return_status OUT NOCOPY VARCHAR2,
587: p_talv_rec IN talv_rec_type) IS
588: item_not_found_error EXCEPTION;
589: l_row_notfound BOOLEAN := TRUE;
590: CURSOR uom_pk_csr (p_uom_code IN okx_units_of_measure_v.uom_code%type) IS
591: SELECT '1'
592: FROM OKC_Timeunit_v
593: WHERE uom_code = p_uom_code
594: and nvl(inactive_date,trunc(sysdate)) >= trunc(sysdate);