357: END IF;
358:
359: SELECT muom.uom_code
360: INTO x_cascaded_table(n).uom_code
361: FROM mtl_units_of_measure muom
362: WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
363: ELSE
364: IF (g_asn_debug = 'Y') THEN
365: asn_debug.put_line('uom_code not dereived as unit_of_measure is null');
421: END IF;
422:
423: SELECT muom.uom_code
424: INTO x_cascaded_table(n).uom_code
425: FROM mtl_units_of_measure muom
426: WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
427: ELSE
428: IF (g_asn_debug = 'Y') THEN
429: asn_debug.put_line('uom_code not dereived as unit_of_measure is null');