APPS.BIS_UTILITIES_PUB SQL Statements

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

Line: 31

     select user_id , user_name
     into x_user_id, x_user_name
     from fnd_user
     where user_id = p_user_id;

Line: 36

     select user_id , user_name
     into x_user_id, x_user_name
     from fnd_user
     where user_name = p_user_name;

Line: 81

     select organization_id , name
     into x_organization_id, x_organization_name
     from hr_all_organization_units
     where organization_id = p_organization_id;

Line: 86

     select organization_id , name
     into x_organization_id, x_organization_name
     from hr_all_organization_units
     where name = p_organization_name;

Line: 169

SELECT level_values_view_name, dimension_level_short_name
FROM bisfv_dimension_levels
WHERE UPPER(level_values_view_name) = UPPER(l_database_object);

Line: 175

   SELECT DATABASE_OBJECT_NAME
   INTO l_database_object
   FROM ak_regions
   WHERE REGION_CODE = UPPER(p_region_code);

Line: 189

      SELECT level_values_view_name, dimension_level_short_name
      INTO l_dim_level_view, l_dim_level_short_name
      FROM bisfv_dimension_levels
      WHERE UPPER(level_values_view_name) = UPPER(l_database_object) and dimension_short_name = p_dimension_short_name;

Line: 198

     SELECT user_id
     INTO l_user_id
     FROM fnd_user
     WHERE user_name = p_user_name;

Line: 353

                      ||' INTERSECT SELECT DISTINCT VALUE, ID '
                      ||' FROM '||p_database_object
                      ||' WHERE responsibility_id IN ( ';

Line: 481

                       ||' INTERSECT SELECT DISTINCT VALUE, ID'
                       || ' FROM '
                       || p_database_object
                       || ' WHERE '
                       || ' ORGANIZATION_ID = '
                       || p_organization_ID
                       || ' AND NVL(ORGANIZATION_TYPE, ''%'') LIKE '
                       || ''''
                       || p_organization_type
                       || '''';

Line: 495

                       ||' INTERSECT SELECT DISTINCT VALUE, ID'
                       || ' FROM '
                       || p_database_object;

Line: 630

     select FUNCTION_NAME
     into l_name
     from fnd_form_functions
       where function_id = p_value;

Line: 651

     select USER_FUNCTION_NAME
     into l_name
     from fnd_form_functions_tl
       where function_id = p_value
       and
       language = nvl(userenv('LANG'),'US');

Line: 685

      select version
    into l_version
    from wf_activities
    where name =p_name
    and item_type = p_type
    and nvl(begin_date, sysdate) <= sysdate
    and nvl(end_date, sysdate) >= sysdate
    and type = 'PROCESS';

Line: 694

      select display_name
    into l_name
    from wf_activities_tl
    where version = l_version
    and name = p_name
    and item_type = p_type
    and language = nvl(userenv('LANG'),'US');

Line: 1697

  SELECT TO_NUMBER(substr(trim(VI.version), 1, instr(trim(VI.version), '.', 1, 1) - 1)) INTO l_db_ver
  FROM v$instance VI
  WHERE VI.instance_role = l_instance_role;

Line: 1773

    SELECT   R.MENU_ID
    FROM     FND_RESPONSIBILITY_VL  R,
             FND_USER_RESP_GROUPS   U
    WHERE    U.USER_ID           =  FND_GLOBAL.USER_ID
    AND      R.VERSION           =  'W'
    AND      U.RESPONSIBILITY_ID =  R.RESPONSIBILITY_ID
    AND      U.START_DATE        <= SYSDATE
    AND     (U.END_DATE IS NULL OR U.END_DATE >= SYSDATE)
    AND      R.START_DATE        <= SYSDATE
    AND     (R.END_DATE IS NULL OR R.END_DATE >= SYSDATE);

Line: 1792

    SELECT FUNCTION_ID
    INTO   l_Function_Id
    FROM   FND_FORM_FUNCTIONS
    WHERE  FUNCTION_NAME = l_Function_Name;

Line: 1832

 *        - BSC_PMD_MD_SELECTMEASURE_PGE
 *        - BSC_BID_SELECTMEASURE_PGE
 *
 *  2) "F" if any of the above conditions fail
 *
 ******************************************************************************/

FUNCTION  Enable_Custom_Kpi
RETURN VARCHAR2 IS
   l_Return_Value    VARCHAR2(1);

Line: 1869

        SELECT property_value
        INTO l_property_value
        FROM bsc_sys_init
        WHERE property_code = G_ENABLE_GEN_SOURCE_REPORT;