APPS.BIL_BI_UTIL_COLLECTION_PKG SQL Statements

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

Line: 48

   SELECT u.oracle_username
     INTO l_schema_name
     FROM fnd_application a,
      fnd_product_installations i,
      fnd_oracle_userid u
    WHERE a.application_short_name = l_app_name
      AND a.application_id = i.application_id
      AND u.oracle_id = i.oracle_id;

Line: 76

  SELECT u.oracle_username
    INTO l_apps_schema_name
    FROM fnd_oracle_userid u
   WHERE u.oracle_id = 900;

Line: 317

  SELECT user_profile_option_name
    INTO l_name
    FROM fnd_profile_options_tl tl
   WHERE tl.profile_option_name = p_profile_name
     AND tl.LANGUAGE = userenv('LANG');