APPS.PER_CPL_SHD SQL Statements

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

Line: 47

    select
       competence_id
      ,language
      ,source_lang
      ,name
      ,competence_alias
      ,behavioural_indicator
      ,description
    from  per_competences_tl
    where competence_id = p_competence_id
    and   language = p_language;

Line: 116

    select
       competence_id
      ,language
      ,source_lang
      ,name
      ,competence_alias
      ,behavioural_indicator
      ,description
    from        per_competences_tl
    where       competence_id = p_competence_id
    and   language = p_language
    for update nowait;

Line: 182

  select cpl.competence_id
       , cd.id_flex_num
       , cd.competence_definition_id
       , cpl.created_by
       , cpl.creation_date
       , cpl.last_updated_by
       , cpl.last_update_date
       , cpl.last_update_login
       , l.language_code
       , cpl.source_lang
       , l.nls_language
       , cpl.behavioural_indicator
       , cpl.description
       , cpl.competence_alias
       , cpl.name
    --
    from per_competences            cpn
       , per_competence_definitions cd
       , per_competences_tl         cpl
       , fnd_languages         l
   where cpn.competence_definition_id =  cd.competence_definition_id
     and cpn.competence_id            =  cpl.competence_id
     and cpl.language                 =  userenv('LANG')
     and l.installed_flag        in ('I', 'B')
     and not exists (select null
                       from per_competences_tl t
                      where t.competence_id = cpl.competence_id
                        and t.language = l.language_code)
   order by l.language_code;

Line: 222

  delete from PER_COMPETENCES_TL T
  where not exists
    (select NULL
    from PER_COMPETENCES B
    where B.COMPETENCE_ID = T.COMPETENCE_ID
    );

Line: 246

  insert into PER_COMPETENCES_TL (
    COMPETENCE_ID,
    NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG,
    BEHAVIOURAL_INDICATOR,
    DESCRIPTION,
    COMPETENCE_ALIAS
  ) values
    (l_competences_tl.competence_id
          , nvl(fnd_flex_ext.get_segs( g_app_code
                                     , g_flex_code
                                     , l_competences_tl.id_flex_num
                                     , l_competences_tl.competence_definition_id
                                     )
              , l_competences_tl.name
              )
          , l_competences_tl.created_by
          , l_competences_tl.creation_date
          , l_competences_tl.last_updated_by
          , l_competences_tl.last_update_date
          , l_competences_tl.last_update_login
          , l_competences_tl.language_code
          , l_competences_tl.source_lang
          , l_competences_tl.behavioural_indicator
          , l_competences_tl.description
          , l_competences_tl.competence_alias);