APPS.HR_DESCR_FLEX_INFO SQL Statements

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

Line: 34

    SELECT dfl.default_context_field_name
          ,dfl.context_column_name
      FROM fnd_descriptive_flexs dfl
          ,fnd_application app
     WHERE dfl.application_id = app.application_id
       AND app.application_short_name = p_application_short_name
       AND dfl.descriptive_flexfield_name = p_descriptive_flexfield_name;

Line: 104

    SELECT dfl.default_context_field_name
          ,dfl.context_column_name
      FROM fnd_descriptive_flexs dfl
          ,fnd_application app
     WHERE dfl.application_id = app.application_id
       AND app.application_short_name = p_application_short_name
       AND dfl.descriptive_flexfield_name = p_descriptive_flexfield_name;

Line: 173

    SELECT col.column_name
      FROM fnd_columns col
          ,fnd_tables tbl
          ,fnd_descriptive_flexs flx
     WHERE col.flexfield_usage_code = 'D'
       AND col.flexfield_application_id = flx.application_id
       AND col.flexfield_name = flx.descriptive_flexfield_name
       AND col.table_id = tbl.table_id
       AND col.application_id = tbl.application_id
       AND tbl.application_id = flx.table_application_id
       AND tbl.table_name = flx.application_table_name
       AND flx.application_id = p_application_id
       AND flx.descriptive_flexfield_name = p_descriptive_flexfield_name;