DBA Data[Home] [Help]

APPS.ZPB_UTIL_PVT SQL Statements

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

Line: 86

  zpb_aw.execute('delete  l_temp_vs  aw ' ||l_dataAw);
Line: 113

  INSERT INTO ZPB_WF_INACTIVE_USERS_GT(
            SESSION_ID,
            USER_NAME

  )
  VALUES(
            p_session_id,
            p_user_name
  );
Line: 161

   select SYS_CONTEXT('USERENV','SESSIONID')  into l_sessionID From dual;
Line: 263

         SELECT model_equation,calc_parameters,member
            FROM zpb_solve_member_defs
            WHERE analysis_cycle_id = p_ac_id
              and source_type = 1200;
Line: 423

        select value into return_val
        from v$parameter
        where name='olap_page_pool_size';