APPS.HRI_BPL_FLEX SQL Statements

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

Line: 22

    SELECT DECODE(NVL(fvt.id_column_type,fvt.value_column_type)
                 ,'D','fnd_date.date_to_canonical('||
                         NVL(fvt.id_column_name,fvt.value_column_name)||')'
                 ,'N','fnd_number.number_to_canonical('||
                         NVL(fvt.id_column_name,fvt.value_column_name)||')'
                 ,NVL(fvt.id_column_name,fvt.value_column_name)
                 ) AS id_column_name
          ,DECODE(fvt.id_column_name,
                    NULL,  DECODE(fvt.meaning_column_type,
                                    'D','fnd_date.date_to_displaydate('||fvt.meaning_column_name||')',
                                  fvt.meaning_column_name),
                  DECODE(fvt.value_column_type,
                           'D','fnd_date.date_to_displaydate('||fvt.value_column_name||')',
                         fvt.value_column_name)
                 ) AS value_column_name
          ,fvt.application_table_name AS from_clause
          ,fvt.additional_where_clause AS where_and_order_clause
      FROM fnd_flex_validation_tables fvt
     WHERE fvt.flex_value_set_id = p_flex_value_set_id;

Line: 92

'SELECT ' || l_distinct_clause || '
  ' || l_id_column_name    || '     id
, ' || l_value_column_name || '     value
, hr_general.start_of_time   effective_start_date
, hr_general.end_of_time     effective_end_date
, ''1'' || ' || l_value_column_name || '     order_by
FROM ' ||
 l_from_clause ||
 l_where_clause;

Line: 123

'SELECT ' || l_distinct_clause || '
 tab.flex_value          id
,tab.flex_value_meaning  value
,NVL(tab.start_date_active, hr_general.start_of_time)
                         effective_start_date
, NVL(tab.end_date_active, hr_general.end_of_time)
                         effective_end_date
,''1'' || tab.flex_value_meaning  order_by
FROM fnd_flex_values_vl tab
WHERE tab.flex_value_set_id = ' || to_char(p_flex_value_set_id) || '
AND tab.enabled_flag = ''Y''';

Line: 151

  SELECT fvs.validation_type
  FROM fnd_flex_value_sets fvs
  WHERE fvs.flex_value_set_id = p_flex_value_set_id;