APPS.PAY_PUMP_GET SQL Statements

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

Line: 18

   select unique_key_id
   into   l_id
   from   hr_pump_batch_line_user_keys
   where  user_key_value = p_user_key_value;

Line: 46

   select rt.object_version_number
   into   l_ovn
   from   pay_run_types_f rt
   ,      hr_pump_batch_line_user_keys key
   where  key.user_key_value = p_run_type_user_key
   and    rt.run_type_id = key.unique_key_id
   and    p_effective_date between
          rt.effective_start_date and rt.effective_end_date;