APPS.HRI_APL_DGNSTC_LOOKUP SQL Statements

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

Line: 12

'SELECT hr_bis.bis_decode_lookup(''' || p_lookup_code || ''',:p_value)
 FROM dual';

Line: 27

'SELECT user_conversion_type
FROM gl_daily_conversion_types
WHERE conversion_type = :p_value';

Line: 43

'SELECT name meaning
FROM fnd_currencies_active_v
WHERE currency_code = :p_value';

Line: 59

'SELECT flex_value_set_name
FROM fnd_flex_value_sets
WHERE flex_value_set_id = :p_value';

Line: 76

'SELECT name
FROM per_organization_structures
WHERE organization_structure_id =:p_value';

Line: 93

'SELECT
 CASE WHEN ((CASE WHEN range1_low  IS NOT NULL OR
                       range1_high IS NOT NULL
                  THEN 1 ELSE 0 END) +
            (CASE WHEN range2_low  IS NOT NULL OR
                       range2_high IS NOT NULL
                  THEN 1 ELSE 0 END) +
            (CASE WHEN range3_low  IS NOT NULL OR
                       range3_high IS NOT NULL
                  THEN 1 ELSE 0 END) +
            (CASE WHEN range4_low  IS NOT NULL OR
                       range4_high IS NOT NULL
                 THEN 1 ELSE 0 END) +
            (CASE WHEN range5_low  IS NOT NULL OR
                       range5_high IS NOT NULL
                  THEN 1 ELSE 0 END) +
            (CASE WHEN range6_low  IS NOT NULL OR
                       range6_high IS NOT NULL
                  THEN 1 ELSE 0 END) +
            (CASE WHEN range7_low  IS NOT NULL OR
                       range7_high IS NOT NULL
                 THEN 1 ELSE 0 END) +
            (CASE WHEN range8_low  IS NOT NULL OR
                       range8_high IS NOT NULL
                  THEN 1 ELSE 0 END) +
            (CASE WHEN range9_low  IS NOT NULL OR
                       range9_high IS NOT NULL
                  THEN 1 ELSE 0 END) +
            (CASE WHEN range10_low  IS NOT NULL OR
                       range10_high IS NOT NULL
                  THEN 1 ELSE 0 END)
          <= 5 )
      THEN ''Y'' ELSE ''N''
 END range
FROM bis_bucket
WHERE short_name = ''' || p_bucket_code || '''';