eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_K_HEADERS

Line 2417: FROM okl_k_headers

2413: -- Get the last interim interest date to check whether
2414: -- Variable Rate processing concurrent program run previously or not
2415: CURSOR get_last_intrm_intrst_dt_csr (p_khr_id IN NUMBER) IS
2416: SELECT date_last_interim_interest_cal
2417: FROM okl_k_headers
2418: WHERE id = p_khr_id;
2419:
2420: -- Cursor to get Interest Calculation Method of a Contract
2421: CURSOR get_interest_calc_method_csr(p_khr_id IN NUMBER) IS

Line 2426: WHERE PQV.PDT_ID IN (SELECT pdt_id FROM OKL_K_HEADERS WHERE id = p_khr_id)

2422: SELECT QVE.VALUE value
2423: FROM OKL_PDT_QUALITYS PQY,
2424: OKL_PDT_PQY_VALS PQV,
2425: OKL_PQY_VALUES QVE
2426: WHERE PQV.PDT_ID IN (SELECT pdt_id FROM OKL_K_HEADERS WHERE id = p_khr_id)
2427: AND PQV.QVE_ID = QVE.ID
2428: AND QVE.PQY_ID = PQY.ID
2429: AND PQY.NAME ='INTEREST_CALCULATION_BASIS';
2430:

Line 3492: FROM OKL_K_HEADERS_FULL_V

3488:
3489: -- This cursor will return deal_type for a particular contract
3490: CURSOR l_lhrfv_csr IS
3491: SELECT deal_type
3492: FROM OKL_K_HEADERS_FULL_V
3493: WHERE id = p_term_rec.p_contract_id;
3494:
3495: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3496: l_api_name VARCHAR2(30) := 'process_evergreen_deprn';

Line 4492: okl_k_headers khr,

4488: --Fix for Bug#14255615
4489: CURSOR rev_rec_method_csr(p_chr_id IN NUMBER) IS
4490: SELECT ppm.revenue_recognition_method
4491: FROM okc_k_headers_b chr,
4492: okl_k_headers khr,
4493: okl_product_parameters_v ppm
4494: WHERE chr.id = p_chr_id
4495: AND chr.id = khr.id
4496: AND khr.pdt_id = ppm.id;

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 6346: l_multi_gaap_yn okl_k_headers.MULTI_GAAP_YN%TYPE := null;

6342: l_pdt_id NUMBER := 0;
6343:
6344: -- MGAAP 7263041 start
6345: l_reporting_pdt_id NUMBER := 0;
6346: l_multi_gaap_yn okl_k_headers.MULTI_GAAP_YN%TYPE := null;
6347: l_valid_gl_date_rep DATE;
6348: l_sob_id_rep NUMBER;
6349: -- MGAAP 7263041 end
6350:

Line 6565: FROM okl_k_headers okl

6561: attribute12,
6562: attribute13,
6563: attribute14,
6564: attribute15
6565: FROM okl_k_headers okl
6566: WHERE okl.id = p_khr_id;
6567: --line dff fields cursor
6568: --this cursor is to populate the
6569: -- desc flex fields columns in okl_txl_xontract_lines_b

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;

Line 9301: OKL_K_HEADERS KHR,

9297: SELECT NVL(OTQV.REPO_QUOTE_INDICATOR_YN, 'N'),
9298: KHR.DEAL_TYPE,
9299: CHR.AUTHORING_ORG_ID
9300: FROM OKL_TRX_QUOTES_V OTQV,
9301: OKL_K_HEADERS KHR,
9302: OKC_K_HEADERS_B CHR
9303: WHERE OTQV.ID = p_quote_id
9304: AND OTQV.KHR_ID = KHR.ID
9305: AND KHR.ID = CHR.ID;

Line 9308: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

9304: AND OTQV.KHR_ID = KHR.ID
9305: AND KHR.ID = CHR.ID;
9306:
9307: l_repo_yn OKL_TRX_QUOTES_V.REPO_QUOTE_INDICATOR_YN%TYPE := 'N';
9308: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
9309: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
9310:
9311: CURSOR c_get_loan_repo_params(p_org_id NUMBER) IS
9312: --SELECT CORPORATE_BOOK,