APPS.JAI_OM_WSH_PKG dependencies on WSH_DELIVERY_TRIPS_V

Line 2571: v_trip_id wsh_delivery_trips_v.trip_id%type;

2567: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
2568: v_debug_flag varchar2(1); -- := 'N'; --Ramananda for File.Sql.35
2569: v_utl_location VARCHAR2(512); --For Log file.
2570: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling
2571: v_trip_id wsh_delivery_trips_v.trip_id%type;
2572: lv_process_flag VARCHAR2(2);
2573: lv_process_message VARCHAR2(1996);
2574: lv_register_type VARCHAR2(5);
2575: lv_rg23a_cess_avlbl VARCHAR2(10);

Line 2963: FROM wsh_delivery_trips_v

2959: IF v_reg_type='ERROR' THEN
2960: BEGIN
2961: SELECT trip_id
2962: INTO v_trip_id
2963: FROM wsh_delivery_trips_v
2964: WHERE delivery_id=p_delivery_id;
2965: EXCEPTION
2966: WHEN OTHERS THEN
2967: NULL;