APPS.HR_FLEXFIELD_INFO SQL Statements

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

Line: 48

select context_column_name,form_context_prompt,default_context_field_name,default_context_value
into   p_column_name,p_column_name_prompt,p_dcontext_field,p_default_context_value
from fnd_descriptive_flexs_vl fdf
    ,fnd_application fa
where descriptive_flexfield_name = p_flex_name
and fa.application_id = fdf.application_id
and fa.application_short_name = p_appl_short_name;

Line: 71

    select meaning
    from   fnd_common_lookups
    where  upper(lookup_code) = upper(p_lookup_code)
    and    lookup_type = 'AK_WEB_REGION_CODES'
    and    application_id = 800
    and    enabled_flag = 'Y';

Line: 250

            select flex_value_set_name into l_flex_value_set_name
            from fnd_flex_value_sets
            where flex_value_set_id = p_segment_info.value_set(i);

Line: 604

  select parent_flex_value_set_id
    from fnd_flex_value_sets
   where flex_value_set_id = p_value_set_id;

Line: 684

   l_select_clause VARCHAR2(2000);

Line: 756

      select 'SELECT ' ||
          l_valueset_r.table_info.value_column_name ||
          decode(l_valueset_r.table_info.meaning_column_name,null,',NULL ',
                 ','||l_valueset_r.table_info.meaning_column_name)||
          decode(l_valueset_r.table_info.id_column_name,null,',NULL ',
                 ','||l_valueset_r.table_info.id_column_name)||
                 ' FROM ' ||
                 l_valueset_r.table_info.table_name || ' ' ||
                 l_valueset_r.table_info.where_clause
      into p_segment_info.sql_text(i)
      from dual;

Line: 883

        l_select_clause := 'SELECT '||l_valueset_r.table_info.
                                                    meaning_column_name||' ';

Line: 886

        l_select_clause := 'SELECT '||l_valueset_r.table_info.
                                                      value_column_name||' ';

Line: 893

      p_segment_info.sql_txt_descr(i) := l_select_clause||l_from_where||
                                                     l_additional_and_clause;

Line: 933

   p_segment_info.sql_text(i) := 'SELECT FFV.FLEX_VALUE,FFVTL.DESCRIPTION,'||
--                       'FFV.FLEX_VALUE_ID  FROM ' ||
--
-- Bizarre fact: AOL require independent values rather than ids
-- even in validate in 'ID' mode.
--
                       'FFV.FLEX_VALUE  FROM ' ||
                       'FND_FLEX_VALUES FFV, FND_FLEX_VALUES_TL FFVTL'||
                       ' WHERE FFV.FLEX_VALUE_ID = FFVTL.FLEX_VALUE_ID' ||
                       ' AND FFV.FLEX_VALUE_SET_ID = ' || L_VALUE_SET_ID ||
                       ' AND FFV.ENABLED_FLAG = ''Y'''||
                       ' AND '''||P_SESSION_DATE||''' BETWEEN'||
                       ' NVL(FFV.START_DATE_ACTIVE,'''||
                       P_SESSION_DATE||''')'||
                     ' AND NVL(FFV.END_DATE_ACTIVE,'''||
                       P_SESSION_DATE||''')'||
                       ' AND FFVTL.LANGUAGE = USERENV(''LANG'')';

Line: 955

         p_segment_info.sql_txt_descr(i) := 'SELECT nvl(DESCRIPTION,FLEX_VALUE)'||
                       ' FROM FND_FLEX_VALUES_VL'||
                       ' WHERE FLEX_VALUE_SET_ID =' || l_value_set_id ||
                       ' AND ENABLED_FLAG = ''Y'''||
                       ' AND '''||P_SESSION_DATE||''' BETWEEN'||
                       ' NVL(START_DATE_ACTIVE,'''||
                                     P_SESSION_DATE||''')'||
                       ' AND NVL(END_DATE_ACTIVE,'''||
                                     P_SESSION_DATE||''')'||
                       ' AND FLEX_VALUE = '||g_app_col_placeholder||
                           p_segment_info.application_column_name(i);

Line: 996

' SELECT FLEX_VALUE,NVL(DESCRIPTION,FLEX_VALUE),FLEX_VALUE'||
'   FROM FND_FLEX_VALUES_VL'||
'  WHERE FLEX_VALUE_SET_ID = '||l_value_set_id||
 '   AND ENABLED_FLAG = ''Y'''||
 '   AND PARENT_FLEX_VALUE_LOW = '||g_app_col_placeholder||l_dep_parent_column_name||
 '   AND '''||P_SESSION_DATE||''' BETWEEN'||
                       ' NVL(START_DATE_ACTIVE,'''||
                       P_SESSION_DATE||''')'||
                       ' AND NVL(END_DATE_ACTIVE,'''||
                       P_SESSION_DATE||''')';

Line: 1007

   p_segment_info.sql_txt_descr(i) := 'SELECT nvl(DESCRIPTION,FLEX_VALUE)'||
                       ' FROM FND_FLEX_VALUES_VL'||
                       ' WHERE FLEX_VALUE_SET_ID =' || l_value_set_id ||
                       ' AND ENABLED_FLAG = ''Y'''||
                       ' AND '''||P_SESSION_DATE||''' BETWEEN'||
                       ' NVL(START_DATE_ACTIVE,'''||
                                     P_SESSION_DATE||''')'||
                       ' AND NVL(END_DATE_ACTIVE,'''||
                                     P_SESSION_DATE||''')'||
                       ' AND FLEX_VALUE = '||g_app_col_placeholder||
                           p_segment_info.application_column_name(i);

Line: 1106

      p_segment_info.sql_text(i) := 'SELECT TERRITORY_SHORT_NAME,NULL,'||
                                    'TERRITORY_CODE FROM FND_TERRITORIES_VL '||
                                    'ORDER BY TERRITORY_SHORT_NAME';

Line: 1109

      p_segment_info.sql_txt_descr(i) := 'SELECT TERRITORY_SHORT_NAME '||
                                         'FROM FND_TERRITORIES_VL '||
                                         'WHERE TERRITORY_CODE = '||g_app_col_placeholder||'COUNTRY';

Line: 1446

          select c.column_type into l_column_type
          from   fnd_application a,
                 fnd_tables t,
                 fnd_columns c
          where  c.column_name = l_application_column_name
          and    c.table_id = t.table_id
          and    c.application_id = a.application_id
          and    t.application_id = a.application_id
          and    t.table_name = p_application_table_name
          and    a.application_short_name = p_application_short_name;

Line: 1895

  SELECT id_flex_structure_code
  INTO l_structure_code
  FROM fnd_id_flex_structures_vl
  WHERE application_id = l_flexfield.application_id
  AND id_flex_code = l_flexfield.flex_code
  AND id_flex_structure_name = p_id_flex_structure_name;