DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_TRX_QUOTES_B

Line 1137: FROM OKL_TRX_QUOTES_B QTE

1133:
1134: -- Get the quote acceptance date
1135: CURSOR get_quote_acc_dt_csr (p_qte_id IN NUMBER) IS
1136: SELECT QTE.date_accepted
1137: FROM OKL_TRX_QUOTES_B QTE
1138: WHERE QTE.id = p_qte_id;
1139:
1140: -- Get the delink_yn value set for the org
1141: CURSOR get_setup_values_csr IS

Line 3341: FROM okl_trx_quotes_b qte

3337: -- get the quote dates
3338: CURSOR quote_dates_csr (p_quote_id IN NUMBER) IS
3339: SELECT trunc(qte.date_effective_from),
3340: trunc(qte.date_accepted)
3341: FROM okl_trx_quotes_b qte
3342: WHERE qte.id = p_quote_id;
3343:
3344: l_eff_from DATE;
3345: l_accpt DATE;

Line 4836: FROM okl_trx_quotes_b qte

4832: SELECT qte.currency_code currency_code,
4833: qte.currency_conversion_type currency_conversion_type,
4834: qte.currency_conversion_rate currency_conversion_rate,
4835: qte.currency_conversion_date currency_conversion_date
4836: FROM okl_trx_quotes_b qte
4837: WHERE qte.id = p_qte_id;
4838:
4839: -- Cursor to obtain refund asset remaining amount
4840: CURSOR l_ref_asset_amt_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_date IN DATE) IS