APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_HEADERS_V

Line 948: FROM OKC_K_HEADERS_b --sechawla 18-dec-07 6690811 : changed OKC_K_HEADERS_V to OKC_K_HEADERS_b

944: -- Cursor to get the end date of contract
945: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
946: CURSOR get_k_end_date_csr ( p_khr_id IN NUMBER) IS
947: SELECT end_date, sts_code --sechawla 18-dec-07 6690811 : added sts_code
948: FROM OKC_K_HEADERS_b --sechawla 18-dec-07 6690811 : changed OKC_K_HEADERS_V to OKC_K_HEADERS_b
949: WHERE id = p_khr_id;
950:
951: --sechawla 18-dec-07 6690811
952: l_k_sts_code VARCHAR2(30);

Line 1536: FROM OKC_K_HEADERS_V khr

1532:
1533: CURSOR l_k_end_csr ( p_khr_id IN NUMBER) IS
1534: SELECT khr.end_date,
1535: khr.sts_code
1536: FROM OKC_K_HEADERS_V khr
1537: WHERE khr.id = p_khr_id;
1538: --akrangan bug 5354501 fix end
1539:
1540: l_try_id NUMBER;

Line 1770: OKC_K_HEADERS_V KHR

1766: SELECT OKLV.id kle_id,
1767: OKLV.name asset_name
1768: FROM OKC_K_LINES_V OKLV,
1769: OKC_LINE_STYLES_V OLSV,
1770: OKC_K_HEADERS_V KHR
1771: WHERE OKLV.chr_id = p_khr_id
1772: AND OKLV.lse_id = OLSV.id
1773: AND OLSV.lty_code = 'FREE_FORM1'
1774: AND OKLV.chr_id = KHR.id

Line 1945: FROM OKC_K_HEADERS_V

1941: -- Cursor to get the k details
1942: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
1943: CURSOR get_k_details_csr (p_khr_id IN NUMBER) IS
1944: SELECT contract_number
1945: FROM OKC_K_HEADERS_V
1946: WHERE id = p_khr_id;
1947: -- asawanka added for debug feature start
1948: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_database_values';
1949: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 3713: FROM OKC_K_HEADERS_V khr

3709: -- RMUNJULU 14-FEB-03 2804703 Added sts_code to cursor
3710: CURSOR l_k_end_csr ( p_khr_id IN NUMBER) IS
3711: SELECT khr.end_date,
3712: khr.sts_code
3713: FROM OKC_K_HEADERS_V khr
3714: WHERE khr.id = p_khr_id;
3715:
3716: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3717: l_api_name VARCHAR2(30) := 'process_evergreen_contract';

Line 6357: okc_k_headers_v khr

6353: SELECT oklv.id kle_id,
6354: oklv.NAME asset_name
6355: FROM okc_k_lines_v oklv,
6356: okc_line_styles_v olsv,
6357: okc_k_headers_v khr
6358: WHERE oklv.chr_id = p_khr_id AND oklv.lse_id = olsv.id AND
6359: olsv.lty_code IN
6360: ('FREE_FORM1', 'FEE', 'SOLD_SERVICE') AND
6361: oklv.chr_id = khr.id AND oklv.sts_code = khr.sts_code;

Line 9083: lx_contract_currency okc_k_headers_v.currency_code%TYPE;

9079: --SECHAWLA Bug # 2726739 : new declarations
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;

Line 9777: FROM OKC_K_HEADERS_V

9773: -- Cursor to get the end date of contract
9774: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9775: CURSOR get_k_end_date_csr ( p_khr_id IN NUMBER) IS
9776: SELECT end_date
9777: FROM OKC_K_HEADERS_V
9778: WHERE id = p_khr_id;
9779:
9780: -- Get the non-cancelled asset return for asset
9781: CURSOR get_asset_return_csr ( p_kle_id IN NUMBER) IS