DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on HR_LOCATIONS

Line 2450: v_hr_location_code hr_locations.location_code%TYPE;

2446: WHEN e_no_shipment_line THEN
2447: ----------------------------------------------------+
2448: DECLARE
2449: --
2450: v_hr_location_code hr_locations.location_code%TYPE;
2451: --
2452: BEGIN
2453: --
2454: ROLLBACK to updatecumkey;

Line 2465: FROM hr_locations hr, wsh_trip_stops tstop

2461: END IF;
2462: --
2463: SELECT location_code
2464: INTO v_hr_location_code
2465: FROM hr_locations hr, wsh_trip_stops tstop
2466: WHERE tstop.stop_id = x_trip_stop_id
2467: AND hr.location_id = tstop.stop_location_id;
2468: --
2469: rlm_message_sv.get_msg_text(