APPS.OKL_AM_CONSOLIDATED_QTE_PVT dependencies on OKL_TRX_QUOTES_V

Line 40: FROM OKL_TRX_QUOTES_V

36: consolidated_qte_id,
37: date_effective_from,
38: date_effective_to,
39: quote_number
40: FROM OKL_TRX_QUOTES_V
41: WHERE id = p_qte_id;
42:
43: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
44: get_quote_values_rec get_quote_values_csr%ROWTYPE;

Line 1153: FROM OKL_TRX_QUOTES_V

1149: -- Cursor to get consolidated quote DB values
1150: CURSOR get_cons_db_vals_csr (p_qte_id IN NUMBER) IS
1151: SELECT accepted_yn,
1152: date_effective_from
1153: FROM OKL_TRX_QUOTES_V
1154: WHERE id = p_qte_id;
1155:
1156:
1157: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1284: FROM OKL_TRX_QUOTES_V

1280:
1281: -- Cursor to get quote details of quotes forming part of consolidated quote
1282: CURSOR get_qtes_of_cons_qte_csr (p_qte_id IN NUMBER) IS
1283: SELECT id
1284: FROM OKL_TRX_QUOTES_V
1285: WHERE consolidated_qte_id = p_qte_id;
1286:
1287: lp_qtev_tbl qtev_tbl_type;
1288: i NUMBER;

Line 1417: FROM OKL_TRX_QUOTES_V qte

1413: -- RMUNJULU 04-FEB-03 2783130 Added cursor to get proper qtp_code
1414: -- get the consolidated quote details
1415: CURSOR get_qte_details_csr ( p_qte_id IN NUMBER) IS
1416: SELECT qte.qtp_code
1417: FROM OKL_TRX_QUOTES_V qte
1418: WHERE qte.id = p_qte_id;
1419:
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1421: l_api_name CONSTANT VARCHAR2(30):= 'update_consolidate_quote';