APPS.BEN_SEED_ACTION_ITEM_TYPES SQL Statements

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

Line: 21

        12 May 00        S Tee      115.2      Insert into MLS table.
        18 Feb 02        gsheelum   115.3      Removed description from
                                                not_exists clause.
                                               Fixing 2217566.
*/
--------------------------------------------------------------------------------
--
g_package varchar2(80) := 'ben_seed_action_item_types';

Line: 40

    insert into ben_actn_typ
    (actn_typ_id,
     business_group_id,
     type_cd,
     name,
     description,
     object_version_number)
    select
     ben_actn_typ_s.nextval,
     p_business_group_id,
     s_at.type_cd,
     s_at.name,
     s_at.description,
     1
     from ben_startup_actn_typ s_at
     where not exists (select 'Y'
                      from ben_actn_typ act
                      where s_at.type_cd        = act.type_cd
                      and   s_at.name           = act.name
                      -- and   s_at.description    = act.description
                      and   p_business_group_id = act.business_group_id);

Line: 64

  insert into ben_actn_typ_tl (
    actn_typ_id,
    name,
    description,
    language,
    type_cd,
    source_lang,
    last_update_date,
    last_updated_by,
    last_update_login,
    created_by,
    creation_date
  ) select
    b.actn_typ_id,
    tl.name,
    tl.description,
    tl.language,
    tl.type_cd,
    tl.source_lang,
    b.last_update_date,
    b.last_updated_by,
    b.last_update_login,
    b.created_by,
    b.creation_date
  from ben_actn_typ b,
       ben_startup_actn_typ_tl tl
  where b.business_group_id = p_business_group_id
  and b.type_cd = tl.type_cd
  and not exists
            (select 'Y'
             from ben_actn_typ_tl t
             where t.actn_typ_id = b.actn_typ_id
             and   t.source_lang = userenv('LANG'));