APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TRX_QUOTES_B

Line 5222: FROM okl_trx_quotes_b qte

5218:
5219: --Bug# 3925492: pagarg +++ Estd. Prop Tax +++++++ Start ++++++++++
5220: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
5221: SELECT trunc(qte.date_effective_from) date_effective_from
5222: FROM okl_trx_quotes_b qte
5223: WHERE qte.id = p_quote_id;
5224:
5225: l_quote_id NUMBER;
5226: l_quote_date_eff DATE;

Line 6806: FROM okl_trx_quotes_b qte

6802:
6803: -- rmunjulu EDAT
6804: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
6805: SELECT trunc(qte.date_effective_from) date_effective_from
6806: FROM okl_trx_quotes_b qte
6807: WHERE qte.id = p_quote_id;
6808:
6809: -- rmunjulu EDAT
6810: l_quote_id NUMBER;

Line 9745: FROM okl_trx_quotes_b qte

9741:
9742: -- rmunjulu EDAT
9743: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
9744: SELECT trunc(qte.date_effective_from) date_effective_from
9745: FROM okl_trx_quotes_b qte
9746: WHERE qte.id = p_quote_id;
9747:
9748: -- rmunjulu EDAT
9749: l_quote_id NUMBER;

Line 10169: FROM okl_trx_quotes_b qte

10165:
10166: -- rmunjulu EDAT
10167: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
10168: SELECT trunc(qte.date_effective_from) date_effective_from
10169: FROM okl_trx_quotes_b qte
10170: WHERE qte.id = p_quote_id;
10171:
10172: -- rmunjulu EDAT
10173: l_quote_id NUMBER;

Line 10682: FROM okl_trx_quotes_b qte

10678:
10679: -- rmunjulu EDAT
10680: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
10681: SELECT trunc(qte.date_effective_from) date_effective_from
10682: FROM okl_trx_quotes_b qte
10683: WHERE qte.id = p_quote_id;
10684:
10685: -- rmunjulu EDAT
10686: l_quote_id NUMBER;

Line 13915: FROM okl_trx_quotes_b qte

13911: l_nbv NUMBER;
13912:
13913: CURSOR get_quote_date_csr (p_qte_id IN NUMBER) IS
13914: SELECT qte.date_effective_from
13915: FROM okl_trx_quotes_b qte
13916: WHERE qte.id = p_qte_id;
13917:
13918: l_quote_eff_date DATE;
13919:

Line 14272: FROM okl_trx_quotes_b qte

14268: RETURN NUMBER IS
14269:
14270: CURSOR get_quote_date_csr (p_qte_id IN NUMBER) IS
14271: SELECT qte.date_effective_from
14272: FROM okl_trx_quotes_b qte
14273: WHERE qte.id = p_qte_id;
14274:
14275: EXPECTED_ERROR EXCEPTION;
14276:

Line 14380: FROM okl_trx_quotes_b qte

14376: AND TQL.qlt_code = 'AMCFIA';
14377:
14378: CURSOR get_quote_date_csr (p_qte_id IN NUMBER) IS
14379: SELECT qte.date_effective_from
14380: FROM okl_trx_quotes_b qte
14381: WHERE qte.id = p_qte_id;
14382:
14383: CURSOR get_base_interest_rate_csr (p_khr_id IN NUMBER) IS
14384: SELECT base_rate