APPS.PQH_PP_DFF_UTILS SQL Statements

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

Line: 37

  SELECT concatenated_segment_delimiter
    FROM fnd_descriptive_flexs
   WHERE descriptive_flexfield_name IN ('PER_PAY_PROPOSALS')
     AND application_id = 800;

Line: 45

  SELECT descriptive_flex_context_code,application_column_name, flex_value_set_id
    FROM fnd_descr_flex_column_usages
   WHERE descriptive_flexfield_name = 'PER_PAY_PROPOSALS'
     AND descriptive_flex_context_code IN ('Global Data Elements', c_context_value)
     AND enabled_flag = 'Y'
     AND display_flag = 'Y'
     AND application_id = 800
   ORDER BY decode(descriptive_flex_context_code,'Global Data Elements',0,1), column_seq_num;