78: AND ROWNUM<=1;
79:
80: cursor get_uom_class(p_uom in varchar2) is
81: select uom_class
82: from mtl_units_of_measure
83: where unit_of_measure = p_uom
84: AND ROWNUM<=1;
85:
86: cursor get_uom(p_uom_code in varchar2) is
84: AND ROWNUM<=1;
85:
86: cursor get_uom(p_uom_code in varchar2) is
87: select unit_of_measure
88: from mtl_units_of_measure
89: where uom_code = p_uom_code
90: AND ROWNUM<=1;
91:
92: /* Changed for Bug 6761395