APPS.AR_MO_GLOBAL_CACHE SQL Statements

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

Line: 43

        g_cache.delete;

Line: 158

      g_cache(l_gt.org_id_t(i)).last_updated_by	  := l_gt.last_updated_by_t(i);

Line: 159

      g_cache(l_gt.org_id_t(i)).last_update_date  := l_gt.last_update_date_t(i);

Line: 160

      g_cache(l_gt.org_id_t(i)).last_update_login := l_gt.last_update_login_t(i);

Line: 275

                  SELECT 'x' into l_exp_flag
                  from ar_system_parameters
                  where org_id = p_org_id;

Line: 292

                   SELECT 'x' into l_exp_flag
                   from ar_system_parameters sp,
                        gl_sets_of_books sob
                   where sob.set_of_books_id = sp.set_of_books_id
                         and sp.org_id = p_org_id;

Line: 311

                      SELECT 'x' into l_exp_flag
                      FROM   ar_system_parameters sp,
                             gl_sets_of_books sob,
                             fnd_currencies c
                      WHERE  sob.set_of_books_id = sp.set_of_books_id
                             and sp.org_id =  p_org_id
                             and  sob.currency_code = c.currency_code;