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 2301: FROM okl_k_headers

2297: -- Get the last interim interest date to check whether
2298: -- Variable Rate processing concurrent program run previously or not
2299: CURSOR get_last_intrm_intrst_dt_csr (p_khr_id IN NUMBER) IS
2300: SELECT date_last_interim_interest_cal
2301: FROM okl_k_headers
2302: WHERE id = p_khr_id;
2303:
2304: -- Cursor to get Interest Calculation Method of a Contract
2305: CURSOR get_interest_calc_method_csr(p_khr_id IN NUMBER) IS

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

2306: SELECT QVE.VALUE value
2307: FROM OKL_PDT_QUALITYS PQY,
2308: OKL_PDT_PQY_VALS PQV,
2309: OKL_PQY_VALUES QVE
2310: WHERE PQV.PDT_ID IN (SELECT pdt_id FROM OKL_K_HEADERS WHERE id = p_khr_id)
2311: AND PQV.QVE_ID = QVE.ID
2312: AND QVE.PQY_ID = PQY.ID
2313: AND PQY.NAME ='INTEREST_CALCULATION_BASIS';
2314:

Line 3376: FROM OKL_K_HEADERS_FULL_V

3372:
3373: -- This cursor will return deal_type for a particular contract
3374: CURSOR l_lhrfv_csr IS
3375: SELECT deal_type
3376: FROM OKL_K_HEADERS_FULL_V
3377: WHERE id = p_term_rec.p_contract_id;
3378:
3379: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3380: l_api_name VARCHAR2(30) := 'process_evergreen_deprn';

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

6176: l_pdt_id NUMBER := 0;
6177:
6178: -- MGAAP 7263041 start
6179: l_reporting_pdt_id NUMBER := 0;
6180: l_multi_gaap_yn okl_k_headers.MULTI_GAAP_YN%TYPE := null;
6181: l_valid_gl_date_rep DATE;
6182: l_sob_id_rep NUMBER;
6183: -- MGAAP 7263041 end
6184:

Line 6399: FROM okl_k_headers okl

6395: attribute12,
6396: attribute13,
6397: attribute14,
6398: attribute15
6399: FROM okl_k_headers okl
6400: WHERE okl.id = p_khr_id;
6401: --line dff fields cursor
6402: --this cursor is to populate the
6403: -- desc flex fields columns in okl_txl_xontract_lines_b

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;

Line 9102: OKL_K_HEADERS KHR,

9098: SELECT NVL(OTQV.REPO_QUOTE_INDICATOR_YN, 'N'),
9099: KHR.DEAL_TYPE,
9100: CHR.AUTHORING_ORG_ID
9101: FROM OKL_TRX_QUOTES_V OTQV,
9102: OKL_K_HEADERS KHR,
9103: OKC_K_HEADERS_B CHR
9104: WHERE OTQV.ID = p_quote_id
9105: AND OTQV.KHR_ID = KHR.ID
9106: AND KHR.ID = CHR.ID;

Line 9109: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

9105: AND OTQV.KHR_ID = KHR.ID
9106: AND KHR.ID = CHR.ID;
9107:
9108: l_repo_yn OKL_TRX_QUOTES_V.REPO_QUOTE_INDICATOR_YN%TYPE := 'N';
9109: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
9110: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
9111:
9112: CURSOR c_get_loan_repo_params(p_org_id NUMBER) IS
9113: --SELECT CORPORATE_BOOK,