APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_LINES_V

Line 576: FROM okc_k_lines_v a , okc_line_styles_b b

572:
573: -- get the active financial asset lines for the contract
574: CURSOR l_okcklines_csr(cp_khr_id IN NUMBER, cp_sts_code IN VARCHAR2) IS
575: SELECT a.id, a.name
576: FROM okc_k_lines_v a , okc_line_styles_b b
577: WHERE a.chr_id = cp_khr_id
578: AND a.lse_id = b.id
579: AND b.lty_code = 'FREE_FORM1'
580: AND a.sts_code = cp_sts_code;

Line 1452: FROM OKC_K_LINES_V OKLV

1448:
1449: -- Cursor to get the asset name for the line number passed
1450: CURSOR k_lines_csr(p_cle_id IN NUMBER) IS
1451: SELECT OKLV.name name
1452: FROM OKC_K_LINES_V OKLV
1453: WHERE OKLV.id = p_cle_id;
1454:
1455: l_name OKC_K_LINES_V.name%TYPE;
1456:

Line 1455: l_name OKC_K_LINES_V.name%TYPE;

1451: SELECT OKLV.name name
1452: FROM OKC_K_LINES_V OKLV
1453: WHERE OKLV.id = p_cle_id;
1454:
1455: l_name OKC_K_LINES_V.name%TYPE;
1456:
1457: -- asawanka added for debug feature start
1458: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_asset_name';
1459: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 1768: FROM OKC_K_LINES_V OKLV,

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

Line 6355: FROM okc_k_lines_v oklv,

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