DBA Data[Home] [Help]

APPS.PQP_VEHICLE_DETAILS_MAPPING SQL Statements

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

Line: 13

SELECT unique_key_id
  FROM hr_pump_batch_line_user_keys
 WHERE user_key_value = p_vehicle_details_user_key;
Line: 41

SELECT object_version_number
  FROM pqp_vehicle_details  pvd,
       hr_pump_batch_line_user_keys key
 WHERE key.user_key_value     = p_user_key_value
   AND pvd.vehicle_details_id = key.unique_key_id ;