DBA Data[Home] [Help]

APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on QP_CACHE_DO_SIZES

Line 44: FROM qp_cache_do_sizes;

40: WHERE o.APPLICATION_ID = 661 and o.PROFILE_OPTION_ID = ov.PROFILE_OPTION_ID (+) and o.APP_ENABLED_FLAG = 'N' and o.RESP_ENABLED_FLAG = 'N' and o.USER_ENABLED_FLAG = 'N';
41:
42: CURSOR cache_do_size_csr IS
43: SELECT count(*)
44: FROM qp_cache_do_sizes;
45:
46: CURSOR cache_stat_csr IS
47: SELECT count(*)
48: FROM qp_cache_stats;

Line 288: FROM qp_cache_do_sizes

284: CURSOR do_size_csr IS
285: SELECT
286: do_name,
287: do_size
288: FROM qp_cache_do_sizes
289: order by do_name;
290:
291: l_cache_key_header_tbl number_tbl_type;
292: l_cache_key_attr_tbl varchar1000_tbl_type;