28: ,khr.currency_conversion_rate currency_conversion_rate
29: ,khr.currency_conversion_type currency_conversion_type
30: ,khr.currency_conversion_date currency_conversion_date
31: ,khr.scs_code scs_code
32: FROM okl_k_headers_full_v khr
33: WHERE khr.id = p_contract_id;
34:
35: g_Product_rec Product_csr%ROWTYPE;
36:
1092: l_legal_entity_id NUMBER;
1093:
1094: -- R12 - START
1095:
1096: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1097: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1098: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1099: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1100: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1093:
1094: -- R12 - START
1095:
1096: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1097: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1098: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1099: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1100: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1101:
1094: -- R12 - START
1095:
1096: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1097: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1098: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1099: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1100: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1101:
1102: -- R12 - END
1095:
1096: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1097: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1098: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1099: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1100: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1101:
1102: -- R12 - END
1103:
1096: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1097: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1098: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1099: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1100: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1101:
1102: -- R12 - END
1103:
1104: