APPS.AME_ATY_SHD SQL Statements

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

Line: 47

    select
     action_type_id
    ,name
    ,procedure_name
    ,start_date
    ,end_date
    ,description
    ,security_group_id
    ,dynamic_description
    ,description_query
    ,object_version_number
    from        ame_action_types
    where       action_type_id = p_action_type_id
    and         p_effective_date
    between start_date and nvl(end_date - (ame_util.oneSecond), sysdate);

Line: 147

  update ame_action_types 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.action_type_id = p_action_type_id
     and p_effective_date between t.start_date
          and nvl(t.end_date - ame_util.oneSecond,sysdate);

Line: 184

    select
     action_type_id
    ,name
    ,procedure_name
    ,start_date
    ,end_date
    ,description
    ,security_group_id
    ,dynamic_description
    ,description_query
    ,object_version_number
    from    ame_action_types
    where   action_type_id = p_action_type_id
    and     p_effective_date
    between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
    for update nowait;

Line: 230

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

Line: 286

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

Line: 289

  elsif (p_datetrack_mode = hr_api.g_delete) then
    p_validation_start_date := p_effective_date;

Line: 363

  select nvl(max(t.object_version_number),0) + 1
    into l_ovn
    from ame_action_types t
   where t.action_type_id = p_action_type_id;

Line: 384

      select count(*)
        from ame_actions
       where action_type_id = p_action_type_id and
         p_start_date between start_date and
           nvl(end_date - ame_util.oneSecond, p_start_date);

Line: 391

      select count(*)
        from ame_action_type_usages
       where action_type_id = p_action_type_id and
         p_start_date between start_date and
           nvl(end_date - ame_util.oneSecond, p_start_date);

Line: 398

      select count(*)
        from ame_approver_type_usages
       where action_type_id = p_action_type_id and
         p_start_date between start_date and
           nvl(end_date - ame_util.oneSecond, p_start_date);

Line: 405

      select count(*)
        from ame_mandatory_attributes
       where action_type_id = p_action_type_id and
         p_start_date between start_date and
           nvl(end_date - ame_util.oneSecond, p_start_date);

Line: 412

      select count(*)
        from ame_action_type_config
       where action_type_id = p_action_type_id and
         p_start_date between start_date and
           nvl(end_date - ame_util.oneSecond, p_start_date);