APPS.JAI_OM_WSH_PKG dependencies on WSH_DELIVERY_TRIPS_V

Line 2442: v_trip_id wsh_delivery_trips_v.trip_id%type;

2438: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
2439: v_debug_flag varchar2(1); -- := 'N'; --Ramananda for File.Sql.35
2440: v_utl_location VARCHAR2(512); --For Log file.
2441: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling
2442: v_trip_id wsh_delivery_trips_v.trip_id%type;
2443: lv_process_flag VARCHAR2(2);
2444: lv_process_message VARCHAR2(1996);
2445: lv_register_type VARCHAR2(5);
2446: lv_rg23a_cess_avlbl VARCHAR2(10);

Line 2834: FROM wsh_delivery_trips_v

2830: IF v_reg_type='ERROR' THEN
2831: BEGIN
2832: SELECT trip_id
2833: INTO v_trip_id
2834: FROM wsh_delivery_trips_v
2835: WHERE delivery_id=p_delivery_id;
2836: EXCEPTION
2837: WHEN OTHERS THEN
2838: NULL;