APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TRX_QUOTES_B

Line 4638: FROM okl_trx_quotes_b qte

4634:
4635: --Bug# 3925492: pagarg +++ Estd. Prop Tax +++++++ Start ++++++++++
4636: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
4637: SELECT trunc(qte.date_effective_from) date_effective_from
4638: FROM okl_trx_quotes_b qte
4639: WHERE qte.id = p_quote_id;
4640:
4641: l_quote_id NUMBER;
4642: l_quote_date_eff DATE;

Line 6208: FROM okl_trx_quotes_b qte

6204:
6205: -- rmunjulu EDAT
6206: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
6207: SELECT trunc(qte.date_effective_from) date_effective_from
6208: FROM okl_trx_quotes_b qte
6209: WHERE qte.id = p_quote_id;
6210:
6211: -- rmunjulu EDAT
6212: l_quote_id NUMBER;

Line 8893: FROM okl_trx_quotes_b qte

8889:
8890: -- rmunjulu EDAT
8891: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
8892: SELECT trunc(qte.date_effective_from) date_effective_from
8893: FROM okl_trx_quotes_b qte
8894: WHERE qte.id = p_quote_id;
8895:
8896: -- rmunjulu EDAT
8897: l_quote_id NUMBER;

Line 9317: FROM okl_trx_quotes_b qte

9313:
9314: -- rmunjulu EDAT
9315: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
9316: SELECT trunc(qte.date_effective_from) date_effective_from
9317: FROM okl_trx_quotes_b qte
9318: WHERE qte.id = p_quote_id;
9319:
9320: -- rmunjulu EDAT
9321: l_quote_id NUMBER;

Line 9825: FROM okl_trx_quotes_b qte

9821:
9822: -- rmunjulu EDAT
9823: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
9824: SELECT trunc(qte.date_effective_from) date_effective_from
9825: FROM okl_trx_quotes_b qte
9826: WHERE qte.id = p_quote_id;
9827:
9828: -- rmunjulu EDAT
9829: l_quote_id NUMBER;

Line 12683: FROM okl_trx_quotes_b qte

12679: l_nbv NUMBER;
12680:
12681: CURSOR get_quote_date_csr (p_qte_id IN NUMBER) IS
12682: SELECT qte.date_effective_from
12683: FROM okl_trx_quotes_b qte
12684: WHERE qte.id = p_qte_id;
12685:
12686: l_quote_eff_date DATE;
12687:

Line 13040: FROM okl_trx_quotes_b qte

13036: RETURN NUMBER IS
13037:
13038: CURSOR get_quote_date_csr (p_qte_id IN NUMBER) IS
13039: SELECT qte.date_effective_from
13040: FROM okl_trx_quotes_b qte
13041: WHERE qte.id = p_qte_id;
13042:
13043: EXPECTED_ERROR EXCEPTION;
13044:

Line 13148: FROM okl_trx_quotes_b qte

13144: AND TQL.qlt_code = 'AMCFIA';
13145:
13146: CURSOR get_quote_date_csr (p_qte_id IN NUMBER) IS
13147: SELECT qte.date_effective_from
13148: FROM okl_trx_quotes_b qte
13149: WHERE qte.id = p_qte_id;
13150:
13151: CURSOR get_base_interest_rate_csr (p_khr_id IN NUMBER) IS
13152: SELECT base_rate