APPS.XTR_COMMON_FUNCTIONS dependencies on XTR_DEAL_DATE_AMOUNTS

Line 232: FROM xtr_deal_date_amounts dda

228: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN IS
229:
230: CURSOR chk_settle_onc IS
231: SELECT 1
232: FROM xtr_deal_date_amounts dda
233: WHERE dda.deal_number = nvl(p_deal_number,dda.deal_number)
234: AND dda.transaction_number =
235: nvl(p_transaction_number, dda.transaction_number)
236: AND settle='Y';

Line 240: FROM xtr_deal_date_amounts dda

236: AND settle='Y';
237:
238: CURSOR chk_settle_onc_interest IS
239: SELECT 1
240: FROM xtr_deal_date_amounts dda
241: WHERE dda.deal_number = nvl(p_deal_number,dda.deal_number)
242: AND dda.transaction_number =
243: nvl(p_transaction_number, dda.transaction_number)
244: AND settle='Y'

Line 250: FROM xtr_deal_date_amounts dda

246: AND dda.amount_type = 'INTSET';
247:
248: CURSOR chk_settle_others(l_date date) IS
249: SELECT 1
250: FROM xtr_deal_date_amounts dda
251: WHERE dda.deal_number = nvl(p_deal_number,dda.deal_number)
252: AND settle='Y'
253: AND amount_date > nvl(l_date,amount_date -1);
254:

Line 613: FROM XTR_DEAL_DATE_AMOUNTS_V

609: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
610:
611: CURSOR chk_recon IS
612: SELECT 1
613: FROM XTR_DEAL_DATE_AMOUNTS_V
614: WHERE deal_number = nvl(p_deal_number, deal_number)
615: AND transaction_number=nvl(p_transaction_number, transaction_number)
616: AND reconciled_pass_code is not null
617: AND reconciled_reference is not null;

Line 691: FROM xtr_deal_date_amounts dda, xtr_rollover_transactions rt

687: AND tax_amount IS NOT NULL;
688:
689: CURSOR chk_tax_settle is
690: SELECT 1
691: FROM xtr_deal_date_amounts dda, xtr_rollover_transactions rt
692: WHERE rt.deal_number=p_deal_number
693: AND rt.transaction_number=v_trans_no
694: AND dda.settle='Y'
695: AND dda.deal_number=0