APPS.PSP_EXTERNAL_EFFORT_LINES_PKG SQL Statements

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

Line: 11

SELECT unique_key_id
  FROM hr_pump_batch_line_user_keys
 WHERE user_key_value = p_ext_effort_line_user_key;

Line: 36

SELECT object_version_number
  FROM psp_external_effort_lines  peel,
       hr_pump_batch_line_user_keys key
 WHERE key.user_key_value     = p_user_key_value
   AND peel.external_effort_line_id = key.unique_key_id ;