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 430: from okl_k_headers

426: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;
427:
428: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS
429: select deal_type
430: from okl_k_headers
431: where deal_type = 'LOAN'
432: and id = p_chr_id;
433:
434: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

Line 469: l_deal_type okl_k_headers.deal_type%type;

465:
466: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALES_TAX_RULES';
467:
468: l_flag VARCHAR2(30) := 'XXXX';
469: l_deal_type okl_k_headers.deal_type%type;
470: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
471: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
472:
473: BEGIN

Line 1096: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

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;

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

Line 1098: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

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

Line 1099: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

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:

Line 1100: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

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: