APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_K_HEADERS

Line 32: FROM okl_k_headers_full_v khr

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:

Line 272: from okl_k_headers

268: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;
269:
270: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS
271: select deal_type
272: from okl_k_headers
273: where deal_type = 'LOAN'
274: and id = p_chr_id;
275:
276: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

Line 311: l_deal_type okl_k_headers.deal_type%type;

307:
308: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALES_TAX_RULES';
309:
310: l_flag VARCHAR2(30) := 'XXXX';
311: l_deal_type okl_k_headers.deal_type%type;
312: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
313: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
314:
315: BEGIN

Line 938: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

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;

Line 939: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%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:

Line 940: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

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

Line 941: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

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:

Line 942: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

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: