APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on QP_CURRENCY_LISTS_B

Line 150: FROM qp_currency_lists_b qpc, qp_list_headers_b qph

146: and inventory_item_id <> 0;
147:
148: CURSOR currency_cache_key_cnt_csr IS
149: SELECT count(DISTINCT qpc.currency_header_id)
150: FROM qp_currency_lists_b qpc, qp_list_headers_b qph
151: WHERE qph.active_flag = 'Y'
152: and qph.currency_code = qpc.base_currency_code;
153:
154: CURSOR modifier_cache_key_csr IS

Line 196: FROM qp_currency_lists_b qpc, qp_list_headers_b qph

192:
193: CURSOR currency_cache_key_csr IS
194: SELECT DISTINCT
195: qpc.currency_header_id
196: FROM qp_currency_lists_b qpc, qp_list_headers_b qph
197: WHERE qph.active_flag = 'Y'
198: and qph.currency_code = qpc.base_currency_code
199: and ROWNUM < 200;
200:

Line 270: FROM qp_list_headers_b qph, qp_currency_lists_b qpc

266: WHERE price_formula_id = p_cache_key;
267:
268: CURSOR currency_csr(p_cache_key varchar2) IS
269: SELECT count(*)
270: FROM qp_list_headers_b qph, qp_currency_lists_b qpc
271: WHERE qph.active_flag = 'Y' and qpc.currency_header_id = p_cache_key and qph.currency_code = qpc.base_currency_code;
272:
273: -- cursor rewritten for sql repository exercise
274: CURSOR currency_line_csr(p_cache_key varchar2) IS