APPS.GME_MOBILE_TXN dependencies on GMO_MATERIAL_DISPENSES

Line 170: SELECT reservation_id from gmo_material_dispenses

166: p_line_type IN NUMBER,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_error_msg OUT NOCOPY VARCHAR2) IS
169: CURSOR get_reservation_id IS
170: SELECT reservation_id from gmo_material_dispenses
171: WHERE dispense_id = p_rsrv_pndlot_id;
172:
173: l_reservation_id NUMBER;
174: l_count NUMBER;