APPS.CZ_ADMIN SQL Statements

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

Line: 5

    SELECT LOGIN_NAME FROM CZ_END_USERS;

Line: 33

    SELECT USER_ID FROM ALL_USERS WHERE USERNAME=sUser_name;

Line: 35

    SELECT UPPER(LOGIN_NAME) FROM CZ_END_USERS;

Line: 37

    SELECT VALUE FROM CZ_DB_SETTINGS
    WHERE SECTION_NAME='DB_USER_ROLES' AND SETTING_ID='0';

Line: 40

    SELECT VALUE FROM CZ_DB_SETTINGS
    WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxDefaultTablespace';

Line: 43

    SELECT VALUE FROM CZ_DB_SETTINGS
    WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxTemporaryTablespace';

Line: 134

        UPDATE CZ_END_USERS SET DBMS_ID=nUserID WHERE UPPER(LOGIN_NAME)=sLogin_name;

Line: 165

   SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE='CZIMPORT';

Line: 178

   SELECT NVL(to_number(VALUE),0) INTO nSeconds FROM CZ_DB_SETTINGS
   WHERE SETTING_ID='MULTISESSION' AND SECTION_NAME='IMPORT';

Line: 200

   SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE like 'CZ_SYNC%';

Line: 213

   SELECT NVL(to_number(VALUE),0) INTO nSeconds FROM CZ_DB_SETTINGS
   WHERE SETTING_ID='MULTISESSION' AND SECTION_NAME='CZPUBLISH';