APPS.RLM_CUM_SV dependencies on HR_LOCATIONS

Line 2440: v_hr_location_code hr_locations.location_code%TYPE;

2436: WHEN e_no_shipment_line THEN
2437: ----------------------------------------------------+
2438: DECLARE
2439: --
2440: v_hr_location_code hr_locations.location_code%TYPE;
2441: --
2442: BEGIN
2443: --
2444: ROLLBACK to updatecumkey;

Line 2455: FROM hr_locations hr, wsh_trip_stops tstop

2451: END IF;
2452: --
2453: SELECT location_code
2454: INTO v_hr_location_code
2455: FROM hr_locations hr, wsh_trip_stops tstop
2456: WHERE tstop.stop_id = x_trip_stop_id
2457: AND hr.location_id = tstop.stop_location_id;
2458: --
2459: rlm_message_sv.get_msg_text(