APPS.AME_STV_SHD SQL Statements

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

Line: 48

    select
     condition_id
    ,string_value
    ,start_date
    ,end_date
    ,security_group_id
    ,object_version_number
    from        ame_string_values
    where       condition_id = p_condition_id
 and    string_value = p_string_value
    and         p_effective_date
    between     start_date
                  and nvl(end_date -  ame_util.oneSecond,p_effective_date);

Line: 147

  update  ame_string_values t
  set     t.end_date          = p_new_end_date
         ,t.last_updated_by   = l_current_user_id
         ,t.last_update_date  = p_new_end_date
         ,t.last_update_login = l_current_user_id
    ,     t.object_version_number = l_object_version_number
  where   t.condition_id = p_condition_id
 and    t.string_value = p_string_value
  and     p_effective_date
  between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
;

Line: 188

    select
     condition_id
    ,string_value
    ,start_date
    ,end_date
    ,security_group_id
    ,object_version_number
    from    ame_string_values
    where   condition_id = p_condition_id
 and    string_value = p_string_value
    and     p_effective_date
    between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
    for update nowait;

Line: 203

    select null
      from AME_CONDITIONS
     where condition_id = p_condition_id
       and p_effective_date between start_date
             and nvl(end_date - ame_util.oneSecond, p_effective_date)
       for update of object_version_number nowait;

Line: 239

  If (p_datetrack_mode <> hr_api.g_insert) then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;

Line: 276

  if (p_datetrack_mode = hr_api.g_update) then
    p_validation_start_date := p_effective_date;

Line: 279

  elsif (p_datetrack_mode = hr_api.g_delete) then
    --
    -- Issue a lock on the parents.
    --
    open csr_lck;

Line: 357

  select nvl(max(t.object_version_number),0) + 1
    into l_ovn
    from ame_string_values t
   where t.condition_id = p_condition_id
 and    t.string_value = p_string_value;