APPS.HR_HISTORY SQL Statements

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

Line: 93

    select userenv('LANG')
      from dual;

Line: 172

    select user
      from user_views
     where view_name = p_view_name;

Line: 179

    select title_prompt
      from dt_title_prompts_tl
     where view_name = p_view_name
       and  language = p_language_code;

Line: 354

    select table_owner
      from user_synonyms syn
     where syn.table_name = p_table_name;

Line: 442

    select effective_start_prompt
         , effective_end_prompt
      from dt_date_prompts_tl
     where language = p_language_code;

Line: 707

  SELECT dcp.column_prompt
    INTO l_col
    FROM dt_column_prompts_tl dcp
   WHERE dcp.view_name   = p_table_name
     AND dcp.column_name = p_column_name
     AND dcp.language    = p_language_code;