DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TRX_QUOTES_V

Line 9587: FROM OKL_TRX_QUOTES_V qte

9583:
9584: --Cusor to obtain the quote net investment
9585: CURSOR c_quote_net_invst_csr(p_quote_id IN NUMBER) IS
9586: SELECT asset_value net_investment
9587: FROM OKL_TRX_QUOTES_V qte
9588: WHERE qte.id = p_quote_id;
9589:
9590: --Cursor to obtain the total quote amount , excluding the billed quote lines
9591: CURSOR c_total_qt_amt(p_quote_id IN NUMBER) IS

Line 12386: FROM okl_trx_quotes_v qte

12382:
12383: -- get the quote type
12384: CURSOR get_qte_type_csr (p_quote_id IN NUMBER) IS
12385: SELECT qte.qtp_code qtp_code
12386: FROM okl_trx_quotes_v qte
12387: WHERE qte.id = p_quote_id;
12388:
12389: -- get asset niv from quote lines
12390: CURSOR get_asset_niv_csr (p_kle_id IN NUMBER, p_quote_id IN NUMBER) IS