APPS.JAI_OM_WSH_PROCESSING_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 158

    SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
           Value,SUBSTR (value,1,INSTR(value,',') -1))
    INTO v_utl_location
    FROM v$parameter
    WHERE name = 'utl_file_dir';

Line: 491

   SELECT TRIP_ID
   into v_trip_id
   FROM WSH_DELIVERY_TRIPS_V
   WHERE DELIVERY_ID=p_delivery_id;