APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 10437: FROM OKL_TXL_QUOTE_LINES_B

10433:
10434: --Cusor to obtain the asset line id
10435: CURSOR c_quote_asset_line(p_quote_id IN NUMBER) IS
10436: SELECT kle_id
10437: FROM OKL_TXL_QUOTE_LINES_B
10438: WHERE QTE_ID = p_quote_id
10439: AND QLT_CODE = 'AMCFIA';
10440:
10441: --Cusor to obtain the quote net investment

Line 10450: FROM OKL_TXL_QUOTE_LINES_B

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
10449: SELECT SUM(amount)
10450: FROM OKL_TXL_QUOTE_LINES_B
10451: WHERE qte_id = p_quote_id
10452: AND qlt_code NOT IN ('AMCFIA','AMCTAX', 'AMYOUB', 'AMCSDD'); -- rmunjulu 3842101 Added security deposit
10453:
10454: l_quote_id NUMBER;

Line 14374: FROM OKL_TXL_QUOTE_LINES_B TQL

14370:
14371:
14372: CURSOR get_tot_outstanding_bal_csr (p_qte_id IN NUMBER) IS
14373: SELECT sum(TQL.asset_value) outstanding_bal
14374: FROM OKL_TXL_QUOTE_LINES_B TQL
14375: WHERE TQL.qte_id = p_qte_id
14376: AND TQL.qlt_code = 'AMCFIA';
14377:
14378: CURSOR get_quote_date_csr (p_qte_id IN NUMBER) IS