DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TRX_QUOTES_V

Line 10444: FROM OKL_TRX_QUOTES_V qte

10440:
10441: --Cusor to obtain the quote net investment
10442: CURSOR c_quote_net_invst_csr(p_quote_id IN NUMBER) IS
10443: SELECT asset_value net_investment
10444: FROM OKL_TRX_QUOTES_V qte
10445: WHERE qte.id = p_quote_id;
10446:
10447: --Cursor to obtain the total quote amount , excluding the billed quote lines
10448: CURSOR c_total_qt_amt(p_quote_id IN NUMBER) IS

Line 13618: FROM okl_trx_quotes_v qte

13614:
13615: -- get the quote type
13616: CURSOR get_qte_type_csr (p_quote_id IN NUMBER) IS
13617: SELECT qte.qtp_code qtp_code
13618: FROM okl_trx_quotes_v qte
13619: WHERE qte.id = p_quote_id;
13620:
13621: -- get asset niv from quote lines
13622: CURSOR get_asset_niv_csr (p_kle_id IN NUMBER, p_quote_id IN NUMBER) IS