APPS.OKC_TCU_PVT dependencies on OKX_UNITS_OF_MEASURE_V

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

476: p_tcuv_rec IN tcuv_rec_type) IS
477: item_not_found_error EXCEPTION;
478: l_row_notfound BOOLEAN := TRUE;
479: /* Commented this cursor for bug 1787982
480: CURSOR uom_pk_csr (p_uom_code IN okx_units_of_measure_v.uom_code%type) IS
481: SELECT '1'
482: FROM OKX_Units_Of_Measure_v
483: WHERE uom_code = p_uom_code;
484: */

Line 482: FROM OKX_Units_Of_Measure_v

478: l_row_notfound BOOLEAN := TRUE;
479: /* Commented this cursor for bug 1787982
480: CURSOR uom_pk_csr (p_uom_code IN okx_units_of_measure_v.uom_code%type) IS
481: SELECT '1'
482: FROM OKX_Units_Of_Measure_v
483: WHERE uom_code = p_uom_code;
484: */
485: /*
486: --Commented this cursor as this cursor should be based on MTL_UNITS_OF_MEASURE

Line 496: FROM OKX_Units_Of_Measure_v

492: AND active_flag = 'Y';
493: */
494: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS
495: SELECT '1'
496: FROM OKX_Units_Of_Measure_v
497: WHERE uom_code = p_uom_code
498: AND (trunc(disable_date) > trunc(sysdate) or
499: disable_date is NULL);
500: l_uom_pk uom_pk_csr%ROWTYPE;