APPS.XTR_COMMON_FUNCTIONS SQL Statements

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

Line: 38

 SELECT	1
 FROM	xtr_deals_v
 WHERE	deal_no     = p_deal_number
 AND	status_code = 'CURRENT';

Line: 86

 SELECT	allow_override
 INTO	l_allow_override
 FROM	Xtr_Dealer_Codes
 WHERE	user_id = fnd_global.user_id;

Line: 231

 SELECT 1
 FROM  	xtr_deal_date_amounts dda
 WHERE 	dda.deal_number = nvl(p_deal_number,dda.deal_number)
 AND   	dda.transaction_number =
		nvl(p_transaction_number, dda.transaction_number)
 AND   	settle='Y';

Line: 239

 SELECT 1
 FROM  	xtr_deal_date_amounts dda
 WHERE 	dda.deal_number = nvl(p_deal_number,dda.deal_number)
 AND   	dda.transaction_number =
		nvl(p_transaction_number, dda.transaction_number)
 AND   	settle='Y'
 AND    actual_settlement_date > p_date --bug 5444438
 AND	dda.amount_type = 'INTSET';

Line: 249

 SELECT 1
 FROM  xtr_deal_date_amounts dda
 WHERE dda.deal_number = nvl(p_deal_number,dda.deal_number)
 AND   settle='Y'
 AND   amount_date > nvl(l_date,amount_date -1);

Line: 347

 SELECT	max(period_end)
 FROM	xtr_batches b,xtr_batch_events e,xtr_revaluation_details r
 WHERE 	r.deal_no    = p_deal_number
 AND 	r.batch_id   = b.batch_id
 AND	b.batch_id   = e.batch_id
 AND	e.event_code = 'REVAL'
 AND 	period_to > nvl(l_date, period_to -1);

Line: 356

 SELECT ('Y')
 FROM	xtr_batches b,xtr_batch_events e,xtr_revaluation_details r
 WHERE 	r.deal_no    = nvl(p_deal_number, r.deal_no)
 AND 	r.batch_id   = b.batch_id
 AND	b.batch_id   = e.batch_id
 AND	e.event_code = 'REVAL'
 AND	r.transaction_no =nvl(p_transaction_number,r.transaction_no);

Line: 447

	SELECT	max(period_to)
   	INTO	l_period_end
	FROM	xtr_accrls_amort
	WHERE	deal_no=p_deal_number
	AND	period_to > p_date;

Line: 460

	SELECT	count(deal_no)
	INTO	l_accrual_check
	FROM	Xtr_Accrls_Amort
	WHERE	deal_no = nvl(p_deal_number,deal_no)
	AND	Trans_no = nvl(p_transaction_number,Trans_no);

Line: 515

 SELECT ('Y')
 FROM	xtr_journals
 WHERE	deal_number =nvl(p_deal_number, deal_number)
 AND	transaction_number =nvl(p_transaction_number,transaction_number);

Line: 521

 SELECT ('Y')
 FROM	xtr_journals
 WHERE	deal_number =nvl(p_deal_number, deal_number)
 AND	transaction_number =nvl(p_transaction_number,transaction_number)
 AND	amount_type = 'INTSET'
 AND    journal_date > p_date; -- for bug 5444438

Line: 533

	SELECT	max(journal_date)
	INTO	l_intset_date
	FROM	xtr_journals
	WHERE	deal_number = p_deal_number
	AND	amount_type = 'INTSET';

Line: 612

	SELECT	1
	FROM	XTR_DEAL_DATE_AMOUNTS_V
	WHERE	deal_number = nvl(p_deal_number, deal_number)
	AND	transaction_number=nvl(p_transaction_number, transaction_number)
	AND	reconciled_pass_code is not null
	AND	reconciled_reference is not null;

Line: 683

 SELECT	transaction_number
 FROM	xtr_rollover_transactions
 WHERE	deal_number = p_deal_number
 AND	maturity_date > l_date
 AND	tax_amount IS NOT NULL;

Line: 690

 SELECT 1
 FROM	xtr_deal_date_amounts dda, xtr_rollover_transactions rt
 WHERE	rt.deal_number=p_deal_number
 AND	rt.transaction_number=v_trans_no
 AND	dda.settle='Y'
 AND	dda.deal_number=0
 AND	dda.deal_type='EXP'
 AND	((rt.tax_settled_reference IS NOT NULL
 AND	dda.transaction_number=rt.tax_settled_reference)
 OR	(rt.principal_tax_settled_ref is not null
 AND	dda.transaction_number=rt.principal_tax_settled_ref));