160: END IF;
161:
162: -- Change status Reservation starts now
163: select count(*) into l_status_code_exists 164: from fnd_lookups 165: where lookup_type = 'GMO_DISP_MTL_STATUS'
166: and lookup_code <> 'DISPENSD'
167: and lookup_code = p_status_code;
168: