APPS.PER_ABT_SHD SQL Statements

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

Line: 47

    select
       absence_attendance_type_id
      ,name
      ,language
      ,source_lang
    from  per_abs_attendance_types_tl
    where absence_attendance_type_id = p_absence_attendance_type_id
    and   language = p_language;

Line: 113

    select
       absence_attendance_type_id
      ,name
      ,language
      ,source_lang
    from        per_abs_attendance_types_tl
    where       absence_attendance_type_id = p_absence_attendance_type_id
    and   language = p_language
    for update nowait;

Line: 175

  delete from per_abs_attendance_types_tl t
  where not exists
    (select null
    from per_absence_attendance_types b
    where b.absence_attendance_type_id = t.absence_attendance_type_id
    );

Line: 182

  update per_abs_attendance_types_tl t set (
      name
    ) = (select
      b.name
    from per_abs_attendance_types_tl b
    where b.absence_attendance_type_id = t.absence_attendance_type_id
    and b.language = t.source_lang)
  where (
      t.absence_attendance_type_id,
      t.language
  ) in (select
      subt.absence_attendance_type_id,
      subt.language
    from per_abs_attendance_types_tl subb, per_abs_attendance_types_tl subt
    where subb.absence_attendance_type_id = subt.absence_attendance_type_id
    and subb.language = subt.source_lang
    and (subb.name <> subt.name
  ));

Line: 201

  insert into per_abs_attendance_types_tl (
    absence_attendance_type_id,
    name,
    created_by,
    creation_date,
    last_updated_by,
    last_update_date,
    last_update_login,
    language,
    source_lang
  ) select /*+ ordered */
    b.absence_attendance_type_id,
    b.name,
    b.created_by,
    b.creation_date,
    b.last_updated_by,
    b.last_update_date,
    b.last_update_login,
    l.language_code,
    b.source_lang
  from per_abs_attendance_types_tl b, fnd_languages l
  where l.installed_flag in ('I', 'B')
  and b.language = userenv('lang')
  and not exists
    (select null
    from per_abs_attendance_types_tl t
    where t.absence_attendance_type_id = b.absence_attendance_type_id
    and t.language = l.language_code);