APPS.HR_ID_FLEX_STRUCTURE_INFO SQL Statements

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

Line: 169

    SELECT ifs.application_column_name
          ,ifs.segment_num
          ,ifs.concatenation_description_len
          ,ifs.default_type
          ,ifs.default_value
          ,ifs.display_flag
          ,ifs.display_size
          ,ifs.enabled_flag
          ,ifs.flex_value_set_id
          ,ifs.form_above_prompt
          ,ifs.form_left_prompt
          ,ifs.maximum_description_len
          ,ifs.required_flag
          ,ifs.segment_name
      FROM fnd_id_flex_segments_vl ifs
          ,fnd_id_flex_structures fst
     WHERE ifs.application_id = fst.application_id
       AND ifs.id_flex_code = fst.id_flex_code
       AND ifs.id_flex_num = fst.id_flex_num
       AND fst.application_id = p_application_id
       AND fst.id_flex_code = p_id_flex_code
       AND fst.id_flex_num = p_id_flex_num
       AND fst.enabled_flag = 'Y';

Line: 416

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