APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_TRX_QUOTES_B

Line 2401: FROM okl_trx_quotes_b

2397: chk_chr_term_rec chk_chr_term_csr%ROWTYPE;
2398:
2399: CURSOR quote_num_csr (p_qte_id IN NUMBER) IS
2400: SELECT quote_number
2401: FROM okl_trx_quotes_b
2402: WHERE ID = p_qte_id;
2403:
2404: quote_num_rec quote_num_csr%ROWTYPE;
2405: i NUMBER;

Line 5214: okl_trx_quotes_b qte,

5210: CURSOR get_term_qte_num (p_khr_id okc_k_headers_b.ID%TYPE) IS
5211: SELECT qte.quote_number
5212: FROM okl_trx_contracts tcn,
5213: okl_trx_types_tl try,
5214: okl_trx_quotes_b qte,
5215: okc_k_headers_b CHR
5216: WHERE tcn.khr_id_old = CHR.orig_system_id1
5217: AND tcn.khr_id_new = CHR.ID
5218: AND tcn_type = 'MAE'

Line 5231: l_qte_num okl_trx_quotes_b.quote_number%TYPE;

5227: AND CHR.ID = p_khr_id;
5228:
5229: l_rem_amt NUMBER;
5230: l_sts_code okc_k_headers_b.sts_code%TYPE;
5231: l_qte_num okl_trx_quotes_b.quote_number%TYPE;
5232: l_approval_path VARCHAR2 (30);
5233: contract_activation_failed EXCEPTION;
5234:
5235: -- Bug# 5038395