APPS.HR_ID_FLEX_INFO SQL Statements

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

Line: 31

    SELECT kfl.set_defining_column_name
      FROM fnd_id_flexs kfl
          ,fnd_application app
     WHERE kfl.application_id = app.application_id
       AND app.application_short_name = p_application_short_name
       AND kfl.id_flex_code = p_id_flex_code;

Line: 87

    SELECT col.column_name
      FROM fnd_columns col
          ,fnd_tables tbl
          ,fnd_id_flexs flx
     WHERE col.flexfield_usage_code = 'K'
       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.id_flex_code = p_id_flex_code;