DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_TRX_QUOTES_B

Line 1115: FROM OKL_TRX_QUOTES_B QTE

1111:
1112: -- Get the quote acceptance date
1113: CURSOR get_quote_acc_dt_csr (p_qte_id IN NUMBER) IS
1114: SELECT QTE.date_accepted
1115: FROM OKL_TRX_QUOTES_B QTE
1116: WHERE QTE.id = p_qte_id;
1117:
1118: -- Get the delink_yn value set for the org
1119: CURSOR get_setup_values_csr IS

Line 3319: FROM okl_trx_quotes_b qte

3315: -- get the quote dates
3316: CURSOR quote_dates_csr (p_quote_id IN NUMBER) IS
3317: SELECT trunc(qte.date_effective_from),
3318: trunc(qte.date_accepted)
3319: FROM okl_trx_quotes_b qte
3320: WHERE qte.id = p_quote_id;
3321:
3322: l_eff_from DATE;
3323: l_accpt DATE;

Line 4814: FROM okl_trx_quotes_b qte

4810: SELECT qte.currency_code currency_code,
4811: qte.currency_conversion_type currency_conversion_type,
4812: qte.currency_conversion_rate currency_conversion_rate,
4813: qte.currency_conversion_date currency_conversion_date
4814: FROM okl_trx_quotes_b qte
4815: WHERE qte.id = p_qte_id;
4816:
4817: -- Cursor to obtain refund asset remaining amount
4818: CURSOR l_ref_asset_amt_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_date IN DATE) IS