Line 248: cursor c_get_mode_meaning is select meaning from fnd_lookups where lookup_type='GMO_DISPENSE_MODE' and lookup_code=l_mode;
244: bs.oprn_id = gop.oprn_id(+) AND
245: msi.hazard_class_id = hzc.hazard_class_id (+);
246:
247: 248: cursor c_get_mode_meaning is select meaning from fnd_lookups where lookup_type='GMO_DISPENSE_MODE' and lookup_code=l_mode; 249:
250: BEGIN
251: -- Initialize return status as success
252: x_return_status := fnd_api.g_ret_sts_success;