APPS.BSC_APPS SQL Statements

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

Line: 74

    h_sql := 'INSERT INTO BSC_TMP_BIG_IN_COND (SESSION_ID, VARIABLE_ID, VALUE_N, VALUE_V)'||
             ' VALUES (USERENV(''SESSIONID''), :1, :2, NULL)';

Line: 142

    h_sql := 'INSERT INTO BSC_TMP_BIG_IN_COND (SESSION_ID, VARIABLE_ID, VALUE_N, VALUE_V)'||
             ' VALUES (USERENV(''SESSIONID''), :1, NULL, :2)';

Line: 161

    SELECT application_id INTO h_appl_id
    FROM fnd_responsibility
    WHERE responsibility_id = x_resp_id;

Line: 191

    SELECT count(*)
    INTO h_count
    FROM bsc_message_logs
    WHERE type = 0
    AND UPPER(source) = UPPER(x_calling_function)
    AND last_update_login = USERENV('SESSIONID');

Line: 284

        SELECT
            meaning
        FROM
            bsc_lookups
        WHERE
            lookup_type = x_lookup_type AND
            lookup_code = x_lookup_code;

Line: 331

        SELECT
            message_text
        FROM
            bsc_messages
        WHERE
            message_name = x_message_name;

Line: 366

    h_sql := 'DELETE FROM BSC_TMP_BIG_IN_COND'||
             ' WHERE SESSION_ID = USERENV(''SESSIONID'')'||
             ' AND VARIABLE_ID = :1';

Line: 372

              'SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND'||
              ' WHERE SESSION_ID = USERENV(''SESSIONID'')'||
              ' AND VARIABLE_ID = '||x_variable_id||
              ')';

Line: 395

    h_sql := 'DELETE FROM BSC_TMP_BIG_IN_COND'||
             ' WHERE SESSION_ID = USERENV(''SESSIONID'')'||
             ' AND VARIABLE_ID = :1';

Line: 402

              'SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND'||
              ' WHERE SESSION_ID = USERENV(''SESSIONID'')'||
              ' AND VARIABLE_ID = '||x_variable_id||
              ')';

Line: 426

    h_sql := 'DELETE FROM BSC_TMP_BIG_IN_COND'||
             ' WHERE SESSION_ID = USERENV(''SESSIONID'')'||
             ' AND VARIABLE_ID = :1';

Line: 433

              'SELECT VALUE_V FROM BSC_TMP_BIG_IN_COND'||
              ' WHERE SESSION_ID = USERENV(''SESSIONID'')'||
              ' AND VARIABLE_ID = '||x_variable_id||
              ')';

Line: 880

    h_sql := 'DELETE FROM BSC_TMP_BIG_IN_COND '||
             'WHERE SESSION_ID = USERENV(''SESSIONID'')';

Line: 893

        SELECT
            object_name
        FROM
            user_objects
        WHERE
            object_name = 'FND_USER';

Line: 940

    h_sql := 'SELECT property_value FROM bsc_sys_init'||
             ' WHERE property_code = :1';

Line: 956

        h_sql := 'SELECT tablespace, index_tablespace'||
                 ' FROM fnd_product_installations'||
                 ' WHERE application_id = 271';

Line: 971

        h_sql := 'SELECT fnd_global.user_id FROM DUAL';

Line: 980

        h_sql := 'SELECT user_id FROM bsc_apps_users WHERE user_name = ''BSCADMIN''';

Line: 991

    h_sql := 'SELECT property_value'||
             ' FROM bsc_sys_init'||
             ' WHERE property_code = :1';

Line: 1025

        SELECT
            VP.value
        FROM
            v$parameter VP
        WHERE
            UPPER(VP.name) = 'UTL_FILE_DIR';

Line: 1163

    SELECT object_name FROM user_objects
    WHERE object_name = upper(x_object);

Line: 1300

    SELECT index_name FROM USER_INDEXES
    WHERE index_name = upper(x_index);

Line: 1304

    SELECT index_name FROM ALL_INDEXES
    WHERE index_name = upper(x_index)
        AND owner = upper(bsc_apps_schema);

Line: 1343

    SELECT table_name FROM USER_TABLES
    WHERE table_name = upper(x_table);

Line: 1347

    SELECT table_name FROM ALL_TABLES
    WHERE table_name = upper(x_table)
        AND owner = upper(bsc_apps_schema);

Line: 1386

    SELECT view_name FROM user_views
    WHERE view_name = upper(x_view);

Line: 1459

        SELECT
            message
        FROM
            bsc_message_logs
        WHERE
            last_update_login = USERENV('SESSIONID')
        ORDER BY
            last_update_date;

Line: 1545

    SELECT COUNT(0)
    INTO   l_count
    FROM   FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur
    WHERE  fu.User_Id           = x_User_Id
    AND    fu.User_Id           = fur.User_Id
    AND    fr.Responsibility_Id = fur.Responsibility_Id
    AND    fr.Application_Id    = fur.Responsibility_Application_Id
    AND    fr.Application_Id    = 271
    AND    SYSDATE BETWEEN fu.Start_Date AND NVL(fu.End_Date, SYSDATE)
    AND    SYSDATE BETWEEN fr.Start_Date AND NVL(fr.End_Date, SYSDATE);

Line: 1589

    SELECT COUNT(0)
    INTO   l_count
    FROM   FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur
    WHERE  fu.User_Id           = x_User_Id
    AND    fu.User_Id           = fur.User_Id
    AND    (fr.responsibility_key = 'BSC_DESIGNER' OR fr.responsibility_key = 'BSC_Manager')
    AND    fr.Responsibility_Id = fur.Responsibility_Id
    AND    fr.Application_Id    = fur.Responsibility_Application_Id
    AND    fr.Application_Id    = 271
    AND    SYSDATE BETWEEN fu.Start_Date AND NVL(fu.End_Date, SYSDATE)
    AND    SYSDATE BETWEEN fr.Start_Date AND NVL(fr.End_Date, SYSDATE)
    AND    SYSDATE BETWEEN fur.Start_Date AND NVL(fur.End_Date, SYSDATE);

Line: 1629

  SELECT  P.FULL_NAME
  FROM    PER_ALL_PEOPLE_F P, FND_USER F
  WHERE   P.PERSON_ID  = F.EMPLOYEE_ID
  AND     F.USER_ID    = x_User_Id;

Line: 1696

    SELECT oracle_username
    FROM fnd_oracle_userid
    WHERE oracle_id between 900 and 999;