APPS.OKL_AM_RESTRUCTURE_RENTS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

	SELECT	qte.id,
		qte.khr_id,
		qte.term,
		qte.pop_code_end,
		qte.purchase_amount,
		qte.purchase_formula,
		khr.after_tax_yield,
		khr.term_duration
	FROM	okl_trx_quotes_v	qte,
		okl_k_headers		khr
	WHERE	qte.id			= p_quote_id
	AND	khr.id			= qte.khr_id;

Line: 45

	SELECT	ste.stream_element_date	start_date,
		SUM (ste.amount)	amount
	FROM	okl_strm_elements	ste,
		okl_streams		stm,
		okc_k_lines_b		kle,
		okc_statuses_b		kls
	WHERE stm.khr_id		= cp_contract_id
	AND	stm.sty_id		= cp_sty_id
	AND	stm.active_yn		= 'Y'
	AND	stm.say_code		= 'CURR'
	AND	kle.id			= stm.kle_id
	AND	kls.code		= kle.sts_code
	AND	kls.ste_code		= 'ACTIVE'
	AND	ste.stm_id		= stm.id
	GROUP	BY ste.stream_element_date
	ORDER	BY ste.stream_element_date;

Line: 165

    lx_req_stream_types_tbl.DELETE;

Line: 171

    lx_rents_tbl.DELETE;

Line: 425

	-- Update quote status
	-- *******************

	l_qtev_rec.id		:= p_quote_id;

Line: 431

	OKL_TRX_QUOTES_PUB.update_trx_quotes (
		p_api_version	=> l_api_version,
		p_init_msg_list	=> OKL_API.G_FALSE,
		x_return_status	=> l_return_status,
		x_msg_count	=> l_msg_count,
		x_msg_data	=> l_msg_data,
		p_qtev_rec	=> l_qtev_rec,
		x_qtev_rec	=> lx_qtev_rec);

Line: 523

		OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines (
			p_api_version	=> l_api_version,
			p_init_msg_list	=> OKL_API.G_FALSE,
			x_return_status	=> l_return_status,
			x_msg_count	=> l_msg_count,
			x_msg_data	=> l_msg_data,
			p_tqlv_tbl	=> l_tqlv_tbl,
			x_tqlv_tbl	=> lx_tqlv_tbl);