APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_LINES_V

Line 692: FROM okc_k_lines_v a , okc_line_styles_b b

688:
689: -- get the active financial asset lines for the contract
690: CURSOR l_okcklines_csr(cp_khr_id IN NUMBER, cp_sts_code IN VARCHAR2) IS
691: SELECT a.id, a.name
692: FROM okc_k_lines_v a , okc_line_styles_b b
693: WHERE a.chr_id = cp_khr_id
694: AND a.lse_id = b.id
695: AND b.lty_code = 'FREE_FORM1'
696: AND a.sts_code = cp_sts_code;

Line 1568: FROM OKC_K_LINES_V OKLV

1564:
1565: -- Cursor to get the asset name for the line number passed
1566: CURSOR k_lines_csr(p_cle_id IN NUMBER) IS
1567: SELECT OKLV.name name
1568: FROM OKC_K_LINES_V OKLV
1569: WHERE OKLV.id = p_cle_id;
1570:
1571: l_name OKC_K_LINES_V.name%TYPE;
1572:

Line 1571: l_name OKC_K_LINES_V.name%TYPE;

1567: SELECT OKLV.name name
1568: FROM OKC_K_LINES_V OKLV
1569: WHERE OKLV.id = p_cle_id;
1570:
1571: l_name OKC_K_LINES_V.name%TYPE;
1572:
1573: -- asawanka added for debug feature start
1574: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_asset_name';
1575: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 1884: FROM OKC_K_LINES_V OKLV,

1880: -- RMUNJULU 20-FEB-03 2757368 Changed cursor to get only active lines
1881: CURSOR k_lines_csr(p_khr_id IN NUMBER) IS
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

Line 6521: FROM okc_k_lines_v oklv,

6517: -- Cursor to get asset, fee and service lines in a contract.
6518: CURSOR k_asst_fee_srvc_lns_csr(p_khr_id IN NUMBER) IS
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