505: BEGIN
506:
507: SELECT Count(*)
508: INTO v_row_count
509: FROM MTL_UNITS_OF_MEASURE_TL
510: WHERE UNIT_OF_MEASURE = x_uom
511: AND UOM_CLASS IN
512: (SELECT UOM_CLASS
513: FROM MTL_UNITS_OF_MEASURE
509: FROM MTL_UNITS_OF_MEASURE_TL
510: WHERE UNIT_OF_MEASURE = x_uom
511: AND UOM_CLASS IN
512: (SELECT UOM_CLASS
513: FROM MTL_UNITS_OF_MEASURE
514: WHERE UNIT_OF_MEASURE IN
515: (SELECT STANDARD_UOM
516: FROM GHG_UOM_CLASSES_ALL
517: WHERE GHG_UOM_CLASS_CODE=x_ghg_uom_class