APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TRX_QUOTES_V

Line 6203: CURSOR l_qte_number_csr ( qteID IN OKL_TRX_QUOTES_V.ID%TYPE ) IS

6199:
6200:
6201: /* Cursor to get the Quote Number. */
6202:
6203: CURSOR l_qte_number_csr ( qteID IN OKL_TRX_QUOTES_V.ID%TYPE ) IS
6204: SELECT quote_number
6205: FROM okl_trx_quotes_v
6206: WHERE id = qteID;
6207:

Line 6205: FROM okl_trx_quotes_v

6201: /* Cursor to get the Quote Number. */
6202:
6203: CURSOR l_qte_number_csr ( qteID IN OKL_TRX_QUOTES_V.ID%TYPE ) IS
6204: SELECT quote_number
6205: FROM okl_trx_quotes_v
6206: WHERE id = qteID;
6207:
6208:
6209: /* Cursor to get the rollover quote fee top/sub-line payments for a

Line 6262: l_qte_num OKL_TRX_QUOTES_V.QUOTE_NUMBER%TYPE;

6258: l_top_fee_ln_id OKL_K_LINES.ID%TYPE;
6259: l_top_fee_ln_name OKC_K_LINES_V.NAME%TYPE;
6260: l_sub_fee_ln_id OKL_K_LINES.ID%TYPE;
6261: l_qte_id OKL_K_LINES.QTE_ID%TYPE;
6262: l_qte_num OKL_TRX_QUOTES_V.QUOTE_NUMBER%TYPE;
6263: p_term_tbl Okl_Trx_Quotes_Pub.qtev_tbl_type;
6264: x_term_tbl Okl_Trx_Quotes_Pub.qtev_tbl_type;
6265: x_err_msg VARCHAR2(1000);
6266: