188: ,khr.currency_conversion_date currency_conversion_date
189: --Bug# 4622198
190: ,khr.scs_code
191: FROM okl_products_v pdt
192: ,okl_k_headers_full_v khr
193: WHERE khr.id = p_contract_id
194: AND khr.pdt_id = pdt.id;
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
192: ,okl_k_headers_full_v khr
193: WHERE khr.id = p_contract_id
194: AND khr.pdt_id = pdt.id;
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
193: WHERE khr.id = p_contract_id
194: AND khr.pdt_id = pdt.id;
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
201:
194: AND khr.pdt_id = pdt.id;
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
201:
202: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
201:
202: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
203: SELECT id trx_try_id
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
201:
202: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
203: SELECT id trx_try_id
204: FROM okl_trx_types_tl