APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_HEADERS_V

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

1060: -- Cursor to get the end date of contract
1061: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
1062: CURSOR get_k_end_date_csr ( p_khr_id IN NUMBER) IS
1063: SELECT end_date, sts_code --sechawla 18-dec-07 6690811 : added sts_code
1064: FROM OKC_K_HEADERS_b --sechawla 18-dec-07 6690811 : changed OKC_K_HEADERS_V to OKC_K_HEADERS_b
1065: WHERE id = p_khr_id;
1066:
1067: --sechawla 18-dec-07 6690811
1068: l_k_sts_code VARCHAR2(30);

Line 1652: FROM OKC_K_HEADERS_V khr

1648:
1649: CURSOR l_k_end_csr ( p_khr_id IN NUMBER) IS
1650: SELECT khr.end_date,
1651: khr.sts_code
1652: FROM OKC_K_HEADERS_V khr
1653: WHERE khr.id = p_khr_id;
1654: --akrangan bug 5354501 fix end
1655:
1656: l_try_id NUMBER;

Line 1886: OKC_K_HEADERS_V KHR

1882: SELECT OKLV.id kle_id,
1883: OKLV.name asset_name
1884: FROM OKC_K_LINES_V OKLV,
1885: OKC_LINE_STYLES_V OLSV,
1886: OKC_K_HEADERS_V KHR
1887: WHERE OKLV.chr_id = p_khr_id
1888: AND OKLV.lse_id = OLSV.id
1889: AND OLSV.lty_code = 'FREE_FORM1'
1890: AND OKLV.chr_id = KHR.id

Line 2061: FROM OKC_K_HEADERS_V

2057: -- Cursor to get the k details
2058: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
2059: CURSOR get_k_details_csr (p_khr_id IN NUMBER) IS
2060: SELECT contract_number
2061: FROM OKC_K_HEADERS_V
2062: WHERE id = p_khr_id;
2063: -- asawanka added for debug feature start
2064: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_database_values';
2065: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 3829: FROM OKC_K_HEADERS_V khr

3825: -- RMUNJULU 14-FEB-03 2804703 Added sts_code to cursor
3826: CURSOR l_k_end_csr ( p_khr_id IN NUMBER) IS
3827: SELECT khr.end_date,
3828: khr.sts_code
3829: FROM OKC_K_HEADERS_V khr
3830: WHERE khr.id = p_khr_id;
3831:
3832: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3833: l_api_name VARCHAR2(30) := 'process_evergreen_contract';

Line 6523: okc_k_headers_v khr

6519: SELECT oklv.id kle_id,
6520: oklv.NAME asset_name
6521: FROM okc_k_lines_v oklv,
6522: okc_line_styles_v olsv,
6523: okc_k_headers_v khr
6524: WHERE oklv.chr_id = p_khr_id AND oklv.lse_id = olsv.id AND
6525: olsv.lty_code IN
6526: ('FREE_FORM1', 'FEE', 'SOLD_SERVICE') AND
6527: oklv.chr_id = khr.id AND oklv.sts_code = khr.sts_code;

Line 9282: lx_contract_currency okc_k_headers_v.currency_code%TYPE;

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

Line 9976: FROM OKC_K_HEADERS_V

9972: -- Cursor to get the end date of contract
9973: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9974: CURSOR get_k_end_date_csr ( p_khr_id IN NUMBER) IS
9975: SELECT end_date
9976: FROM OKC_K_HEADERS_V
9977: WHERE id = p_khr_id;
9978:
9979: -- Get the non-cancelled asset return for asset
9980: CURSOR get_asset_return_csr ( p_kle_id IN NUMBER) IS