484: */
485: /*
486: --Commented this cursor as this cursor should be based on MTL_UNITS_OF_MEASURE
487:
488: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS
489: SELECT '1'
490: FROM okc_timeunit_v
491: WHERE uom_code = p_uom_code
492: AND active_flag = 'Y';
486: --Commented this cursor as this cursor should be based on MTL_UNITS_OF_MEASURE
487:
488: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS
489: SELECT '1'
490: FROM okc_timeunit_v
491: WHERE uom_code = p_uom_code
492: AND active_flag = 'Y';
493: */
494: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS
490: FROM okc_timeunit_v
491: WHERE uom_code = p_uom_code
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