DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_K_HEADERS_V

Line 5227: FROM OKL_K_HEADERS_V

5223:
5224: -- Cursor to get the product of the contract
5225: CURSOR prod_id_csr (p_khr_id IN NUMBER) IS
5226: SELECT pdt_id
5227: FROM OKL_K_HEADERS_V
5228: WHERE id = p_khr_id;
5229:
5230: -- Cursor to get the code_combination_id for the transaction id and
5231: -- transaction table

Line 6164: FROM okl_k_headers_v khr,

6160: chr.scs_code -- rmunjulu 4622198
6161: ,chr.org_id --akrangan added for sla ae uptake cr
6162: ,khr.multi_gaap_yn --MGAAP 7263041
6163: ,pdt.reporting_pdt_id --MGAAP 7263041
6164: FROM okl_k_headers_v khr,
6165: okc_k_headers_b chr, -- rmunjulu Bug 4162862
6166: okl_products pdt
6167: WHERE khr.id = p_khr_id AND khr.id = chr.id -- rmunjulu Bug 4162862
6168: AND khr.pdt_id = pdt.ID; -- MGAAP 7263041

Line 9084: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;

9080: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
9081: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
9082: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9083: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
9084: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
9085: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;
9086: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;
9087: lx_converted_amount NUMBER;
9088:

Line 9085: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;

9081: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
9082: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9083: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
9084: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
9085: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;
9086: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;
9087: lx_converted_amount NUMBER;
9088:
9089: -- rmunjulu EDAT

Line 9086: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;

9082: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9083: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
9084: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
9085: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;
9086: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;
9087: lx_converted_amount NUMBER;
9088:
9089: -- rmunjulu EDAT
9090: l_quote_accpt_date DATE;