DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_K_HEADERS_V

Line 5393: FROM OKL_K_HEADERS_V

5389:
5390: -- Cursor to get the product of the contract
5391: CURSOR prod_id_csr (p_khr_id IN NUMBER) IS
5392: SELECT pdt_id
5393: FROM OKL_K_HEADERS_V
5394: WHERE id = p_khr_id;
5395:
5396: -- Cursor to get the code_combination_id for the transaction id and
5397: -- transaction table

Line 6330: FROM okl_k_headers_v khr,

6326: chr.scs_code -- rmunjulu 4622198
6327: ,chr.org_id --akrangan added for sla ae uptake cr
6328: ,khr.multi_gaap_yn --MGAAP 7263041
6329: ,pdt.reporting_pdt_id --MGAAP 7263041
6330: FROM okl_k_headers_v khr,
6331: okc_k_headers_b chr, -- rmunjulu Bug 4162862
6332: okl_products pdt
6333: WHERE khr.id = p_khr_id AND khr.id = chr.id -- rmunjulu Bug 4162862
6334: AND khr.pdt_id = pdt.ID; -- MGAAP 7263041

Line 9283: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;

9279: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
9280: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
9281: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9282: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
9283: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
9284: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;
9285: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;
9286: lx_converted_amount NUMBER;
9287:

Line 9284: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;

9280: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
9281: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9282: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
9283: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
9284: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;
9285: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;
9286: lx_converted_amount NUMBER;
9287:
9288: -- rmunjulu EDAT

Line 9285: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;

9281: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9282: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
9283: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
9284: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;
9285: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;
9286: lx_converted_amount NUMBER;
9287:
9288: -- rmunjulu EDAT
9289: l_quote_accpt_date DATE;