206: ,khr.khr_attribute12
207: ,khr.khr_attribute13
208: ,khr.khr_attribute14
209: ,khr.khr_attribute15
210: FROM okl_k_headers_full_v khr
211: WHERE khr.id = p_contract_id;
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
209: ,khr.khr_attribute15
210: FROM okl_k_headers_full_v khr
211: WHERE khr.id = p_contract_id;
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
210: FROM okl_k_headers_full_v khr
211: WHERE khr.id = p_contract_id;
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
218:
211: WHERE khr.id = p_contract_id;
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
218:
219: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
218:
219: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
220: SELECT id trx_try_id
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
218:
219: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
220: SELECT id trx_try_id
221: FROM okl_trx_types_tl