APPS.GL_GLXRLSEG_XMLP_PKG SQL Statements

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

Line: 17

    SELECT value_attribute_type
    FROM   FND_FLEX_VALIDATION_QUALIFIERS
    WHERE  id_flex_code = 'GL#'
    AND    id_flex_application_id = 101
    AND    flex_value_set_id = valset
    ORDER BY assignment_date, value_attribute_type;

Line: 41

  SELECT fs.flex_value_set_id, fs.application_column_name,
         fst.form_above_prompt
  into  value_set_id, colname, prompt
  from fnd_id_flex_segments fs, fnd_id_flex_segments_tl fst
  where fs.id_flex_code = 'GL#'
  and fs.enabled_flag = 'Y'
  and fs.id_flex_num = P_STRUCT_NUM
  and fs.segment_name = P_SEGMENT_NAME
  and fs.application_id = 101
  and fst.application_id = fs.application_id + 0
  and fst.id_flex_code = fs.id_flex_code
  and fst.id_flex_num = fs.id_flex_num
  and fst.application_column_name = fs.application_column_name
  and fst.language = userenv('LANG');

Line: 56

  select attribute_value
  into printswitch
  from fnd_segment_attribute_values
  where application_id = 101
  and  id_flex_code = 'GL#'
  and  id_flex_num = P_STRUCT_NUM
  and  segment_attribute_type = 'GL_ACCOUNT'
  and  application_column_name = colname;

Line: 91

  SELECT ffvs.validation_type
  INTO   seg_type
  FROM   fnd_flex_value_sets ffvs
  WHERE  ffvs.flex_value_set_id = value_set_id;

Line: 97

       select vs.parent_flex_value_set_id
       into  p_value_set_id
       from fnd_flex_value_sets vs
       where vs.flex_value_set_id = value_set_id;

Line: 102

       SELECT  distinct fst.form_above_prompt
       into  p_prompt
       from  fnd_id_flex_segments fs, fnd_id_flex_segments_tl fst
       where fs.application_id = 101
       and   fs.id_flex_code = 'GL#'
       and   fs.enabled_flag = 'Y'
       and   fs.id_flex_num = P_STRUCT_NUM
       and   fs.flex_value_set_id = p_value_set_id
       and   fst.application_id = fs.application_id + 0
       and   fst.id_flex_code = fs.id_flex_code
       and   fst.id_flex_num = fs.id_flex_num
       and   fst.application_column_name = fs.application_column_name
       and   fst.language = userenv('LANG');