APPS.WSH_UPGRADE_PICK_SLIP_DATA_NEW dependencies on WSH_DEPARTURES

Line 102: FROM wsh_departures

98: CURSOR C2 IS SELECT wsh_trips_s.nextval FROM sys.dual;
99:
100: CURSOR C3 (l_departure_id NUMBER) IS
101: SELECT 1
102: FROM wsh_departures
103: WHERE departure_id = l_departure_id;
104:
105: temp NUMBER;
106: temp_id NUMBER;

Line 336: INSERT INTO wsh_departures(

332:
333:
334: Get_Departure( p_departure_id, v_departure_name);
335:
336: INSERT INTO wsh_departures(
337: organization_id,
338: departure_id,
339: name,
340: source_code,