APPS.XTR_BISF_P SQL Statements

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

Line: 13

select base_rate
 from xtr_deals
 where deal_no=to_number(p_deal_number);

Line: 38

select internal_ticket_no
 from xtr_deals
 where deal_no=to_number(p_deal_number);

Line: 43

select internal_ticket_no
 from xtr_rollover_transactions
 where deal_number=to_number(p_deal_number)
   and transaction_number=p_transaction_number;

Line: 73

 select journal_date
 from xtr_journals
 where deal_type=p_deal_type and
       deal_number=p_deal_number and
       amount_type in ('INTSET','COMPOND') and
       journal_date < p_journal_date and
       accounted_dr <>0
 order by journal_date desc;

Line: 83

 select sum(ACCOUNTED_DR)
 from xtr_journals
 where deal_type=p_deal_type and
       deal_number=p_deal_number and
       amount_type ='INTADJ' and
       journal_date > p_prev_journal_date and
       journal_date <= p_journal_date and
       accounted_dr <>0;

Line: 93

 select journal_date
 from xtr_journals
 where deal_type=p_deal_type and
       deal_number=p_deal_number and
       amount_type ='INTSET' and
       accounted_dr <> 0 and
       journal_date < p_journal_date and
       transaction_number in (select a.transaction_number from xtr_rollover_transactions a
         where a.deal_number=p_deal_number
       start with a.cross_ref_to_trans = p_transaction_number
       connect by  (a.deal_number = PRIOR a.deal_number and a.cross_ref_to_trans = PRIOR a.transaction_number))
 order by journal_date desc;

Line: 108

 select sum(ACCOUNTED_DR)
 from xtr_journals
 where deal_type=p_deal_type and
       deal_number=p_deal_number and
       amount_type ='INTADJ' and
       journal_date > l_prev_journal_date and
       journal_date <= p_journal_date and
       accounted_dr <> 0 and
       transaction_number in (select a.transaction_number from xtr_rollover_transactions a
         where a.deal_number=p_deal_number
       start with a.cross_ref_to_trans = p_transaction_number
       connect by  (a.deal_number = PRIOR a.deal_number and a.cross_ref_to_trans = PRIOR a.transaction_number));