APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 9580: FROM OKL_TXL_QUOTE_LINES_B

9576:
9577: --Cusor to obtain the asset line id
9578: CURSOR c_quote_asset_line(p_quote_id IN NUMBER) IS
9579: SELECT kle_id
9580: FROM OKL_TXL_QUOTE_LINES_B
9581: WHERE QTE_ID = p_quote_id
9582: AND QLT_CODE = 'AMCFIA';
9583:
9584: --Cusor to obtain the quote net investment

Line 9593: FROM OKL_TXL_QUOTE_LINES_B

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
9592: SELECT SUM(amount)
9593: FROM OKL_TXL_QUOTE_LINES_B
9594: WHERE qte_id = p_quote_id
9595: AND qlt_code NOT IN ('AMCFIA','AMCTAX', 'AMYOUB', 'AMCSDD'); -- rmunjulu 3842101 Added security deposit
9596:
9597: l_quote_id NUMBER;

Line 13142: FROM OKL_TXL_QUOTE_LINES_B TQL

13138:
13139:
13140: CURSOR get_tot_outstanding_bal_csr (p_qte_id IN NUMBER) IS
13141: SELECT sum(TQL.asset_value) outstanding_bal
13142: FROM OKL_TXL_QUOTE_LINES_B TQL
13143: WHERE TQL.qte_id = p_qte_id
13144: AND TQL.qlt_code = 'AMCFIA';
13145:
13146: CURSOR get_quote_date_csr (p_qte_id IN NUMBER) IS