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:
934: l_legal_entity_id NUMBER;
935:
936: -- R12 - START
937:
938: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
939: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
940: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
941: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
942: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
935:
936: -- R12 - START
937:
938: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
939: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
940: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
941: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
942: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
943:
936: -- R12 - START
937:
938: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
939: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
940: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
941: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
942: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
943:
944: -- R12 - END
937:
938: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
939: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
940: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
941: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
942: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
943:
944: -- R12 - END
945:
938: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
939: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
940: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
941: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
942: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
943:
944: -- R12 - END
945:
946: