APPS.AME_ITU_SHD SQL Statements

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

Line: 48

    select
     application_id
    ,item_class_id
    ,item_id_query
    ,item_class_order_number
    ,item_class_par_mode
    ,item_class_sublist_mode
    ,start_date
    ,end_date
    ,object_version_number
    from  ame_item_class_usages
    where item_class_id = p_item_class_id
     and  application_id = p_application_id
     and  p_effective_date
            between start_date and nvl(end_date - (1/86400),p_effective_date);

Line: 153

  update ame_item_class_usages t
     set t.end_date              = p_new_effective_end_date
        ,t.last_updated_by       = l_current_user_id
        ,t.last_update_date      = p_new_effective_end_date
        ,t.last_update_login     = l_current_user_id
        ,t.object_version_number = l_object_version_number
   where t.item_class_id = p_item_class_id
     and t.application_id = p_application_id
     and p_effective_date between t.start_date
          and nvl(t.end_date - (1/86400),sysdate);

Line: 192

    select
     application_id
    ,item_class_id
    ,item_id_query
    ,item_class_order_number
    ,item_class_par_mode
    ,item_class_sublist_mode
    ,start_date
    ,end_date
    ,object_version_number
    from    ame_item_class_usages
    where   item_class_id = p_item_class_id
 and    application_id = p_application_id
    and     p_effective_date
    between start_date and nvl(end_date - (1/86400), sysdate)
    for update nowait;

Line: 238

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

Line: 273

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

Line: 276

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

Line: 349

  select nvl(max(t.object_version_number),0) + 1
    into l_ovn
    from ame_item_class_usages t
   where t.item_class_id = p_item_class_id
 and    t.application_id = p_application_id;

Line: 373

    select count(*)
      from
        ame_attribute_usages attru,
        ame_attributes attr
    where attru.attribute_id   = attr.attribute_id
      and attru.application_id = p_application_id
      and attr.item_class_id   = p_item_class_id
      and p_start_date BETWEEN attru.start_date
             and nvl(attru.end_date -(1/86400),p_start_date)
      and p_start_date BETWEEN attr.start_date
            and nvl(attr.end_date - (1/86400),p_start_date);

Line: 386

    select count(*)
      from
        ame_rule_usages rlu,
        ame_rules rl
    where rlu.rule_id      = rl.rule_id
      and rlu.item_id      = p_application_id
      and rl.item_class_id = p_item_class_id
      and ((p_start_date between rl.start_date and nvl(rl.end_date - ame_util.oneSecond, p_start_date)) or
           (p_start_date < rl.start_date and rl.start_date < nvl(rl.end_date,rl.start_date + ame_util.oneSecond)))
      and ((p_start_date between rlu.start_date and nvl(rlu.end_date - ame_util.oneSecond, p_start_date)) or
           (p_start_date < rlu.start_date and rlu.start_date < nvl(rlu.end_date,rlu.start_date + ame_util.oneSecond)));