APPS.AD_CONFIG SQL Statements

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

Line: 9

   SELECT decode(p_release_type,
             'B', substr(release_name, 1,
                     decode(sign(instr(release_name, ' ')), 1,
                              instr(release_name, ' ')-1,
                              length(release_name))),
              release_name)
   INTO   l_release_name
   FROM fnd_product_groups;

Line: 25

   SELECT nvl(multi_org_flag, 'N')
   INTO   l_flag
   FROM   fnd_product_groups;

Line: 36

   SELECT nvl(multi_lingual_flag, 'N')
   INTO   l_flag
   FROM   fnd_product_groups;

Line: 47

   SELECT nvl(multi_currency_flag, 'N')
   INTO   l_flag
   FROM   fnd_product_groups;

Line: 63

  SELECT to_number(profile_option_value)
  INTO   l_org_id
  FROM   fnd_profile_option_values pov
       , fnd_profile_options po
  WHERE  po.profile_option_name = 'ORG_ID'
  AND    pov.profile_option_id = po.profile_option_id
  AND    pov.level_id = 10001;