APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_TRX_QUOTES_B

Line 2704: FROM okl_trx_quotes_b

2700: chk_chr_term_rec chk_chr_term_csr%ROWTYPE;
2701:
2702: CURSOR quote_num_csr (p_qte_id IN NUMBER) IS
2703: SELECT quote_number
2704: FROM okl_trx_quotes_b
2705: WHERE ID = p_qte_id;
2706:
2707: quote_num_rec quote_num_csr%ROWTYPE;
2708: i NUMBER;

Line 5754: okl_trx_quotes_b qte,

5750: CURSOR get_term_qte_num (p_khr_id okc_k_headers_b.ID%TYPE) IS
5751: SELECT qte.quote_number
5752: FROM okl_trx_contracts tcn,
5753: okl_trx_types_tl try,
5754: okl_trx_quotes_b qte,
5755: okc_k_headers_b CHR
5756: WHERE tcn.khr_id_old = CHR.orig_system_id1
5757: AND tcn.khr_id_new = CHR.ID
5758: AND tcn_type = 'MAE'

Line 5771: l_qte_num okl_trx_quotes_b.quote_number%TYPE;

5767: AND CHR.ID = p_khr_id;
5768:
5769: l_rem_amt NUMBER;
5770: l_sts_code okc_k_headers_b.sts_code%TYPE;
5771: l_qte_num okl_trx_quotes_b.quote_number%TYPE;
5772: l_approval_path VARCHAR2 (30);
5773: contract_activation_failed EXCEPTION;
5774:
5775: -- Bug# 5038395