APPS.ICX_POR_INTERMEDIA_INDEX SQL Statements

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

Line: 8

        select language_code,
               -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
               nls_language,
               installed_flag
        from   fnd_languages
        where  installed_flag in ('B', 'I');

Line: 47

    SELECT oracle_username
    INTO xAppsSchemaName
    FROM fnd_oracle_userid
    WHERE read_only_flag = 'U';

Line: 55

    select index_tablespace
    into ctx_index_tbsp
    from fnd_product_installations
    where application_id = '178';

Line: 62

    select tablespace
    into ctx_data_tbsp
    from fnd_product_installations
    where application_id = '178';