APPS.HR_DESCR_FLEX_CONTEXT_INFO SQL Statements

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

Line: 169

    SELECT fcu.application_column_name
          ,fcu.column_seq_num
          ,fcu.concatenation_description_len
          ,fcu.default_type
          ,fcu.default_value
          ,fcu.display_flag
          ,fcu.display_size
          ,fcu.enabled_flag
          ,fcu.end_user_column_name
          ,fcu.flex_value_set_id
          ,fcu.form_above_prompt
          ,fcu.form_left_prompt
          ,fcu.maximum_description_len
          ,fcu.required_flag
      FROM fnd_descr_flex_col_usage_vl fcu
          ,fnd_descr_flex_contexts_vl ctx
     WHERE fcu.application_id = ctx.application_id
       AND fcu.descriptive_flexfield_name = ctx.descriptive_flexfield_name
       AND fcu.descriptive_flex_context_code = ctx.descriptive_flex_context_code
       AND ctx.application_id = p_application_id
       AND ctx.descriptive_flexfield_name = p_descriptive_flexfield_name
       AND ctx.descriptive_flex_context_code = p_descr_flex_context_code
       AND ctx.enabled_flag = 'Y'
    UNION
    SELECT fcu.application_column_name
          ,fcu.column_seq_num
          ,fcu.concatenation_description_len
          ,fcu.default_type
          ,fcu.default_value
          ,fcu.display_flag
          ,fcu.display_size
          ,fcu.enabled_flag
          ,fcu.end_user_column_name
          ,fcu.flex_value_set_id
          ,fcu.form_above_prompt
          ,fcu.form_left_prompt
          ,fcu.maximum_description_len
          ,fcu.required_flag
      FROM fnd_descr_flex_col_usage_vl fcu
          ,fnd_descr_flex_contexts_vl ctx
     WHERE fcu.application_id = ctx.application_id
       AND fcu.descriptive_flexfield_name = ctx.descriptive_flexfield_name
       AND fcu.descriptive_flex_context_code = ctx.descriptive_flex_context_code
       AND ctx.application_id = p_application_id
       AND ctx.descriptive_flexfield_name = p_descriptive_flexfield_name
       AND ctx.global_flag = 'Y'
       AND ctx.enabled_flag = 'Y'
       AND NOT EXISTS (SELECT NULL
                         FROM fnd_descr_flex_col_usage_vl cu1
                             ,fnd_descr_flex_contexts_vl cx1
                        WHERE cu1.application_id = cx1.application_id
                          AND cu1.descriptive_flexfield_name = cx1.descriptive_flexfield_name
                          AND cu1.descriptive_flex_context_code = cx1.descriptive_flex_context_code
                          AND cu1.application_column_name = fcu.application_column_name
                          AND cx1.application_id = ctx.application_id
                          AND cx1.descriptive_flexfield_name = ctx.descriptive_flexfield_name
                          AND cx1.descriptive_flex_context_code = p_descr_flex_context_code
                          AND NVL(cx1.global_flag,'N') <> 'Y'
                          AND cx1.enabled_flag = 'Y');

Line: 453

    SELECT app.application_id
      FROM fnd_application app
     WHERE app.application_short_name = p_application_short_name;